Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sevvalk
Creator
Creator

Calculating the difference between two dates.

Hello, I want to get the difference between two dates.
Date format is like 17.11.2023 18:45:12. Can you help me with this?

Labels (5)
1 Solution

Accepted Solutions
brunobertels
Master
Master

Hi 

example below using inerval function : 

interval(Timestamp#('17.11.2023 18:45:12','dd.mm.yyyy hh:mm:ss') - Timestamp#('15.11.2023 12:20:52','dd.mm.yyyy hh:mm:ss'),'DD hh:mm:ss')

 

will give you 

2 06:24:20 

View solution in original post

1 Reply
brunobertels
Master
Master

Hi 

example below using inerval function : 

interval(Timestamp#('17.11.2023 18:45:12','dd.mm.yyyy hh:mm:ss') - Timestamp#('15.11.2023 12:20:52','dd.mm.yyyy hh:mm:ss'),'DD hh:mm:ss')

 

will give you 

2 06:24:20