2 Replies Latest reply on May 28, 2018 2:24 PM by David_CHATEL

    AF - Convert time difference into days only

    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