Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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