I am trying to create a field with Date-Formula format that will auto-populate with a date that is 30 days after a date enter into another field.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a "Corrective Action Response Evaluation" field that when populated triggers a "Corrective Action Verification Due Date" that is due 30 days after the response evaluation.  I am trying to make the "Corrective Action Verification Due Date" field auto-populate with a date that is the "Corrective Action Response Evaluation" + 30 days.  

I cannot get a formula to work here.  Any assistance would be GREAT!

Photo of Sam

Sam

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Brendan

Brendan

  • 40 Points
Hi Oliver,

Try creating a Formula Date field with the following formula:

[Corrective Action Response Evaluation] + Days(30)

Hope this helps!  Give this a try and let me know how it goes.

Thanks
Photo of Sam

Sam

  • 0 Points
Worked like a charm!!  I think I was just trying to make it more complicated... :relieved:
Photo of Brendan

Brendan

  • 40 Points
Great!  Happy to help