Formula for subtracting dates
If I wanted to use a number saying for saying how many days have gone by since a specific date, how would I handle that formula field? So like "3" would mean it's been 3 days (Today) since the schedu...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you want to have a formula result in a number as to the number of days, you cvan do
ToDays(Today() - [Scheduled date])
The inner part would result in a Duration of 3 days, but a Duration is not a number, it is a sense of time ...
I find it much easier to convert that to the number of days.
If you want to add days to a date it would be like
[Scheduled date] + Days(3)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ToDays(Today() - [Scheduled date])
The inner part would result in a Duration of 3 days, but a Duration is not a number, it is a sense of time ...
I find it much easier to convert that to the number of days.
If you want to add days to a date it would be like
[Scheduled date] + Days(3)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Oh my gosh, Mark, this worked so great! Thank you so much!!
------------------------------
Michael Brumfield
------------------------------
