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



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,