Calculating the difference between two dates.

[sevvalk]

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?

[brunobertels · Accepted solution]

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