difference between timestamps

[ah009]

hi trying to find the difference between this 2 timestamps

09/10/2021 17:17

24/06/2021 13:56

02/08/2021 09:46

09/10/2021 16:18

24/06/2021 12:53

02/08/2021 08:42

first completion date 

second is created date

want to find the time difference between both

[Or]

[Created Date] - [Completion Date]. Generally speaking, you can subtract dates or timestamps to get the difference between them.

[vchuprina]

Hi,

You can use the interval function

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/Formatt...

Example:

I use Timestamp# funtion to recognize string as a timestamp.

After this I use Interval function, it allows to find difference in a different formats ('d' - day,  'hh:mm'- hours and minutes, etc.)

Data:
LOAD
*,
Interval(Date1-Date2, 'hh:mm') AS Diff
;
LOAD
Timestamp#(Date1,'D/M/YYYY hh:mm')AS Date1,
Timestamp#(Date2,'D/M/YYYY hh:mm')AS Date2;
LOAD * Inline[
Date1, Date2
09/10/2021 17:17,09/10/2021 16:18
24/06/2021 13:56,24/06/2021 12:53
24/07/2021 12:01,24/07/2021 05:10
02/08/2021 09:46,02/08/2021 08:42
];

Result:

Regards,

Vitalii

[ah009]

Thank you, 

[ah009 · Accepted solution]

thank you.
exactly what i need 

[vchuprina]

Welcome🙂