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