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")
Amazing! thank you so much!
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!
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.
