Discussions

Expand all | Collapse all

Formula to calculate a future date

  • 1.  Formula to calculate a future date

    Posted 25 days ago
    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
    ------------------------------


  • 2.  RE: Formula to calculate a future date

    Posted 25 days 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
    ------------------------------