Add a date reminder

Im trying to create an automated reminder - after setting a certain date record, a new field will be automatically filled with a date + 30 days

Example: I filled the 1/1/21 in Date 1 - and I want Date 2 to be auto-populated with 1/2/21

Help please :pray: :pray: :pray:
Thank you!

Hi @Liran_hamburg and welcome to the community!

U can use a formula field for this.

If you want 30 days later:
DATEADD({Date 1}, 30, "days")

If you want 1 month later:
DATEADD({Date 1}, 1, "month")

If you want the first day of the next month:
"01-"&DATETIME_FORMAT(DATEADD({Date 1}, 1, "month"), "MM-YYYY")

1 Like

Amazing! thank you so much!

1 Like


If this solutions works for you, then please mark my post as β€œsolution” so others can find it to :slight_smile: .

@Liran_hamburg Glad to know that you got the answer you were seeking! As @Databaser said, please mark his comment above as the solution to your question. This helps others who may be searching with similar questions. Thanks!


This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.