Forum Discussion

FatimaKhan's avatar
FatimaKhan
Qrew Trainee
2 years ago

Formula for Date

Hi,

I am trying to figure out a formula that will show 2 days after the record is created.

I have a date field [Response Needed By] and I want it to automatically populate the date for 2 days after the record was created.

Thank you

------------------------------
Fatima Khan
------------------------------
  • You can make a formula date field.

    [Response Needed By] = [Date Created] + Days(2)

    ------------------------------
    Mike Tamoush
    ------------------------------
    • FatimaKhan's avatar
      FatimaKhan
      Qrew Trainee
      I wanted to make [Response Needed By] the field with the formula. That formula is giving me an error. Should I create another field?

      ------------------------------
      Fatima Khan
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander
        Sorry, I forgot Date Created is a date/time field. Try this:

        ToDate([Date Created]) + Days(2)

        ------------------------------
        Mike Tamoush
        ------------------------------