Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

¿How to calculate the time with current date/hour?

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:

   

IDCreatedNow
79925/04/2016 10:30:00 AM25/04/2016 11:07
79825/04/2016 10:15:00 AM25/04/2016 11:07
79725/04/2016 10:11:00 AM25/04/2016 11:07
79625/04/2016 09:44:00 AM25/04/2016 11:07
79525/04/2016 09:23:00 AM25/04/2016 11:07
79425/04/2016 09:05:00 AM25/04/2016 11:07
79325/04/2016 08:11:00 AM25/04/2016 11:07
79225/04/2016 07:53:00 AM25/04/2016 11:07
79125/04/2016 07:31:00 AM25/04/2016 11:07

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: ¿How to calculate the time with current date/hour?

May be try this:

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

UPDATE: Now() function includes date and time.

4 Replies
MVP
MVP

Re: ¿How to calculate the time with current date/hour?

May be try this:

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

UPDATE: Now() function includes date and time.

Not applicable

Re: ¿How to calculate the time with current date/hour?

Hi Sunny T,

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

Thanks for your response.

MVP
MVP

Re: ¿How to calculate the time with current date/hour?

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

Not applicable

Re: ¿How to calculate the time with current date/hour?

Thanks! It is working!

Community Browser