Forum Discussion

Qrew Member

12 years ago

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.

Qrew Captain

7 years ago

if the date field is a date/time type, you may have to have something like:

ToDays(Today() - ToDate([Date/Time Field]))

KatrinaE
Qrew Cadet
7 years ago
That worked! Thanks!
KatrinaE
Qrew Cadet
7 years ago
I have another issue, so I'm trying to calculate the difference between the assigned start date from todays date. This is for the user to know how many days he has left to start the project, now I would like a value of NA to indicate the project has already started. How do I go about that?