4 Replies Latest reply: Apr 25, 2016 12:22 PM by Sunny Talwar RSS

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

    Sebastián Garcíá

      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.