topic Re: subtract timestamp with current timestamp? in App Development

subtract timestamp with current timestamp?

gauravgg — Fri, 02 Dec 2016 04:29:11 GMT

I have a date field as below

Date

01/12/2016 01:20:00 PM

03/12/2016 03:30:00 PM

06/12/2016 05:20:00 PM

I want to subtract the above Date field with the current date time and the output should be in hh:mm:ss

(i want to find the difference between dates ---(Date - current timestamp))

can anyone help me

Thanks in Advance

sushil353 — Fri, 02 Dec 2016 04:44:41 GMT

Try this:

=Date(Today()-Date#(Date,'DD/DD/YYYY hh:mm:ss TT'),'hh:mm:ss')

jonathandienst — Fri, 02 Dec 2016 04:58:06 GMT

If DateField is a string:

=Interval(Today()-Date#(DateField,'DD/MM/YYYY hh:mm:ss TT'),'hh:mm:ss')

If you do the date interpretation during the initial load, then its simpler:

=Interval(Today() - DateField, 'hh:mm:ss')

gauravgg — Fri, 02 Dec 2016 05:01:25 GMT

its not working

tresB — Fri, 02 Dec 2016 05:06:19 GMT

Interval(Today()-Date#(DateField,'DD/MM/YYYY hh:mm:ss TT'),'hh:mm:ss')

Above expression (already suggested by Jonathan) should work. Could you post a qvw that shows how it is not working?