topic ¿How to calculate the time with current date/hour? in App Development

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

Wed, 22 Dec 2021 15:42:54 GMT

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 — Mon, 25 Apr 2016 16:19:05 GMT

May be try this:

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

UPDATE: Now() function includes date and time.

Mon, 25 Apr 2016 16:21:08 GMT

Hi Sunny T,

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

Thanks for your response.

sunny_talwar — Mon, 25 Apr 2016 16:22:44 GMT

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

Mon, 25 Apr 2016 16:22:57 GMT

Thanks! It is working!