Number of Days Between Dates
I am trying to generate a report of sorts that shows the number of days between TODAY and the most recent occurrence of something in one of my fields? What is the best way to do this?
Forum Discussion
Make a formula numeric field
Todays(Today() - [my other field])
Todays(Today() - [my other field])
You will need to get that "most recent day" as a field on the record so that it is available to use in a formula. If these Events are in a child table, you will need to edit the relationship to create a Summary field of the maximum Event Date.