calculate days between different da

[tongw]

calculate days between different date and time:

Please help me if anything wrong here:

Problem is here: e.g, test_dt=3/22/2017, test_tm=10:50:00; dx_dt=3/24/2017, dx_tm=9:45:00 but the result is 3.00 (days) not 2.96(days)


if( dx_tm>=test_tm, (daysafter( test_dt, dx_dt )) + ((secondsafter(test_tm, dx_tm)/3600))/24, ((daysafter( test_dt, dx_dt )) + (1-abs(secondsafter(test_tm, dx_tm)/3600))/24))


Appreciate your help!!

 

[mbalent]

I suggest you test your expression by adding some temp columns to separate the time and day components to make sure the pieces are being evaluated properly.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[xsyguy]

Try converting the DaysAfter between the dates to seconds by multiplying it by 86400, then add the
SecondsAfter between the time, then convert the result back to days by dividing it by 86400. For example:

ldec_days = ((DaysAfter(test_dt, dx_dt) * 86400) + SecondsAfter(test_tm, dx_tm)) / 86400