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 you have a formula numeric field, the formula would be
ToDays(Today()-[date field])
The today() function returns today's date. The similarly (but different) named function "ToDays ( )" converts a duration result to the number of days, i.e. a number.
ToDays(Today()-[date field])
The today() function returns today's date. The similarly (but different) named function "ToDays ( )" converts a duration result to the number of days, i.e. a number.
- Instead of using a date field could I use a sample status? I wanna see how I can check how many day a sample is sitting in a certain status
_
