Discussions

Expand all | Collapse all

Formula to calculate a future date

  • 1.  Formula to calculate a future date

    Posted 11 days ago
    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.

    ------------------------------
    Mylissa
    ------------------------------


  • 2.  RE: Formula to calculate a future date

    Posted 11 days ago
    So 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
    ------------------------------



  • 3.  RE: Formula to calculate a future date

    Posted 11 days ago
    I want the result to be a date. I want the anchor date to be the date of the date/time field.

    ------------------------------
    Mylissa Price
    ------------------------------



  • 4.  RE: Formula to calculate a future date

    Posted 11 days ago
    np,
    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
    ------------------------------



  • 5.  RE: Formula to calculate a future date

    Posted 11 days ago
    Perfect! Thanks for your help!!

    ------------------------------
    Mylissa Price
    ------------------------------