1 Reply Latest reply on Dec 12, 2016 2:52 PM by Marc MOUSSA

    Subtracting or adding two date field

    chakradhar kakani

      Hello All,

       

      Can anyone please tell me what happens if we subtract two date & time fields. For example I have attached a screenshot where i have calculated a field using two date & Time fields. I have ended up results in decimals. But not sure what was that.

      so in my case as per screenshot i have calculated ( [Evnt End Time] - [Evnt Start Time] ) i have got result of 0.000127 is that difference of hours or mins or seconds.

       

      Appreciate the help.

       

      Thanks