Formula to calculate a future date

Question

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 [Period of Performance End Date] (formula Date).

My example is:
[Period of Performance Start Date] 02/08/2019
[Contract Duration] 5.5 (meaning 5 1/2 years)
[Period of Performance End Date] - 08/07/2024 -
Sample Formula below:
AdjustYear([Period of Performance Start Date], [Contract Duration])

BUT IT ISN'T WORKING. I assume it is because I have a decimal in my [Contract Duration] field, but I don't see any other way to swing this. Please Help!

------------------------------
Amber Polston
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community