1 2 Previous Next 20 Replies Latest reply on May 9, 2019 1:18 PM by Michel Caissie

    Difference between dates "Day" fields

    JASON SYLVIA

      I have 2 date time fields 4/19/2019 7:49 and 4/18/2019 23:59.  Using my Datediff function of datediff ('hour', 4/18/2019 23:59. 4/19/2019 7:49)/24 I end up with a difference of .125.  I simply want to distinguish the number of days between the day fields and if the difference is greater than 0.  I was using Datediff "day" initially but when I had used that function and ran into data like 4/10/2019 7:17 and 4/9/2019 23:59 it counts it as 0 when I would want that calculated as 1 (I assume because it is not a full 24 hours). 

        1 2 Previous Next