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])
My other field is a numeric field that tracks the number of events that occur each day. These events don't occur everyday. How can I count back to the most recent day that one of these events occurred?