Discussions

Expand all | Collapse all

duration between date created and date modified field

  • 1.  duration between date created and date modified field

    Posted 10-05-2018 18:26
    Trying to create a formula field where the result shows the difference between the [date created] and [date modified]

    However I only want it to show the number of hours.

    tried doing this but it come up with a weird date and time as a result

    [date modified]-[date created]


  • 2.  RE: duration between date created and date modified field

    Posted 10-05-2018 19:12
    you can make it a formula numeric field type.

    ToHours([date modified]-[date created])


  • 3.  RE: duration between date created and date modified field

    Posted 10-05-2018 21:11
    this worked perfect - thanks