How can you subtract a date field from the current day's date?
For example. Date field is 1/1/14. Todays date is 1/15/14. Answer = 15 days.
Forum Discussion
if the date field is a date/time type, you may have to have something like:
ToDays(Today() - ToDate([Date/Time Field]))
ToDays(Today() - ToDate([Date/Time Field]))
That worked! Thanks!