Dates

[areli1990]

how I can subtract two dates format: ' DD / MM / YYYY hh : mm : ss [ .fff ] TT ' ) . ?

for example : 05/20/2016 3:49:24 PM - 5/18/2016 1:10:54 PM

I appreciate support

[sunny_talwar · Accepted solution]

May be this:

Interval(TimeStamp#(Field1, 'D/M/YYYY hh:mm:ss TT') - TimeStamp#(Field2, 'D/M/YYYY hh:mm:ss TT'))

Or this if you want only days difference:

Date(Floor(TimeStamp#(Field1, 'D/M/YYYY hh:mm:ss TT'))) - Date(Floor(TimeStamp#(Field2, 'D/M/YYYY hh:mm:ss TT')))

[areli1990]

Thank you very much for your support