Add a date reminder

[Liran_hamburg]

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

[Databaser]

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")

[Liran_hamburg]

Amazing! thank you so much!

[Databaser · Accepted solution]

@Liran_hamburg

If this solutions works for you, then please mark my post as “solution” so others can find it to :slightly_smiling_face: .

[Justin_Barrett]

@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!