Forum Discussion

MylissaPrice's avatar
MylissaPrice
Qrew Trainee
5 years ago

Formula to calculate a future date

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years 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
    ------------------------------
    • MylissaPrice's avatar
      MylissaPrice
      Qrew Trainee
      5 years 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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years 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
        ------------------------------