Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
thank you.
exactly what i need
[Created Date] - [Completion Date]. Generally speaking, you can subtract dates or timestamps to get the difference between them.
Hi,
You can use the interval function
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
Thank you,
thank you.
exactly what i need
Welcome🙂