Solved: ¿How to calculate the time with current date/hour? - Qlik Community

Report Inappropriate Content · ‎2016-04-25

Hi there,

I have a problem with calculation time.

I have a field with Date and Time, and i need calculate how many time is running from now to Created Date:

For example, in the ID 799 the time should be 00:37:00. (Now-Created)

I dont know how to create Now function (Date+hour)

Best regards.

sunny_talwar · ‎2016-04-25

May be try this:

Interval(Now() - Created, 'hh:mm:ss')

UPDATE: Now() function includes date and time.

sunny_talwar · ‎2016-04-25

May be try this:

Interval(Now() - Created, 'hh:mm:ss')

UPDATE: Now() function includes date and time.

Report Inappropriate Content · ‎2016-04-25

Hi Sunny T,

The Now() function has date (25/04/2016) ?

Thanks for your response.

sunny_talwar · ‎2016-04-25

Try =TimeStamp(Now()) and it should display you the time component as well.

Report Inappropriate Content · ‎2016-04-25

Thanks! It is working!