AnsweredAssumed Answered

AF - Convert time difference into days only

Question asked by David_CHATEL on May 28, 2018
Latest reply on May 28, 2018 by David_CHATEL

Hello,

 

I'm wondering which could be the easiest way to convert the delta between two dates into days, without any mention of hours, minutes, and so on.
Typical result format I get when subtracting 2 dates is : 26.02:59:00.9090159 (26 days, 2 hours, 59 minutes, etc...)
I thought playing with InStr function to find the position of the first dot and then extract only the left portion but I think that there could a much smarter and cleaner way to proceed.

 

 

 

 

Thanks in advance for your answers,

 

David

Outcomes