DIFF DATE/TIME

[fmazzarelli]

Hi Community,

first of all

I thank the people who are helping me.

My need is to calculate the elapsed time between two dates

Request Date 02/11/2016 - Closed Date: 03/11/2016 (dd/mm/yyyy)

Request Time 10:01:01    -  Closed Time 10:00:00

Elapsed time 23:59:59

I'm not able to calculate the time between dates.

Could you help me?

[Anonymous]

Have a look at the Interval() function

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/FormattingFunctions/Interval....

[fmazzarelli]

thanks you've been really helpful in addressing to the solution.