Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

May be try this:

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

UPDATE: Now() function includes date and time.

View solution in original post

4 Replies

May be try this:

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

UPDATE: Now() function includes date and time.

View solution in original post

Not applicable

Hi Sunny T,

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

Thanks for your response.

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

Not applicable

Thanks! It is working!