Skip to main content

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 🙏 🙏 🙏

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


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


Amazing! thank you so much!


Amazing! thank you so much!


@Liran_hamburg


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


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


Reply