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])
I'm not quite understanding how to get the most recent day into the equation. I have a date field, but the only one that matters is the most recent.