Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')))
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')))
Thank you very much for your support