Forum Discussion

AmberPolston's avatar
AmberPolston
Qrew Cadet
5 years ago

Formula to calculate a future date

I must say...  Date field typically don't give me a hard time; however, this one has me stumped... I have a [Period of Performance Start Date], a [Contract Duration] field (numeric field) and a [Pe...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If you allow the contractor ration to be entered in decimal years then you were obviously not super concerned about the accuracy of the exact number of days.
So try this

[Period of Performance Start Date] + Days(Round([Contract Duration]*365.25))


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------