Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be try this:

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

UPDATE: Now() function includes date and time.

View solution in original post

4 Replies
sunny_talwar

May be try this:

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

UPDATE: Now() function includes date and time.

Not applicable
Author

Hi Sunny T,

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

Thanks for your response.

sunny_talwar

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

Not applicable
Author

Thanks! It is working!