topic Re: Dates in QlikView

Dates

areli1990 — Fri, 17 Jun 2016 18:07:52 GMT

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 — Fri, 17 Jun 2016 18:14:36 GMT

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 — Fri, 17 Jun 2016 20:54:13 GMT

Thank you very much for your support