Formula to calculate a future date
This is probably a simple ask but I am new to using formulas. I would like to use a field that is date/time to calculate a new date that is 60 calendar days in the future. -------------------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo to be clear, do you want the result to be a date or a date / time field. Also what is anchor date field that you want to add 60 days to.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I want the result to be a date. I want the anchor date to be the date of the date/time field.
------------------------------
Mylissa Price
------------------------------
------------------------------
Mylissa Price
------------------------------
- MarkShnier__Younp,
try this
ToDate([My Date Field]) + Days(60)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Perfect! Thanks for your help!!
------------------------------
Mylissa Price
------------------------------