Add a date reminder

Hello!
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!
Liran

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

@Liran_hamburg

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!

2 Likes

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