Mike
Qrew Member
4 years ago

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 scheduled date (March 20th).  Any help would be amazing!

Thank you!

------------------------------
Michael Brumfield
------------------------------
• If 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
------------------------------
• Mike
Qrew Member
Oh my gosh, Mark, this worked so great!  Thank you so much!!

------------------------------
Michael Brumfield
------------------------------