Need help on DatetimeDifference

[Pinky]

Hi,

I am using the below formula to calculate the Date difference.

DateTimeDiff(DateTimeParse([Max_DateTime_Out],"%y/%m/%d %H:%M:%S"),DateTimeParse([Min_DateTime_Out],"%y/%m/%d %H:%M:%S"),"Seconds").

The formula is only subtracting minutes not seconds. If you see the below data first incident number dates difference is showing zero where as it should show 16 seconds. I have tried using "seconds" and "Minutes" in formula but still the date differenec is Zero. I want to subtract the seconds even the hour and minute is same.

Can i know where am i doing wrong? Thanks!

Incident Number	Priority	Max_DateTime_Out	Min_DateTime_Out	DateDiff
INC000018021039	Low	02/23/2018 19:28:41	02/23/2018 19:28:25	0
INC000018021096	Low	02/23/2018 20:50:14	02/23/2018 20:45:57	5
INC000018021284	Medium	02/24/2018 0:38:14	02/24/2018 0:35:00	3

[LordNeilLord · Accepted solution]

Hey @Pinky

Try this:

DateTimeDiff(DateTimeParse([Max_DateTime_Out],
"%m/%d/%Y %H:%M:%S"),
DateTimeParse([Min_DateTime_Out],
"%m/%d/%Y %H:%M:%S"),"Seconds")