Skip to main content
Question

duration between date created and date modified field

  • October 5, 2018
  • 0 replies
  • 45 views

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]
This topic has been closed for replies.

you can make it a formula numeric field type.

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

  • Author
  • Registered
  • October 6, 2018
this worked perfect - thanks