Wednesday, January 23, 2019

Calculate the Difference between a Date/Time field and a Date field


Image

The following formula will give user the difference in days. Add this to the results tab of a custom saved search.


Formula(Numeric): ROUND({ID of date field}-{ID of other date field})

Note: Either field can be used for the date/time field value.

No comments:

Post a Comment