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
Best answer by Databaser
Amazing! thank you so much!
If this solutions works for you, then please mark my post as “solution” so others can find it to :slightly_smiling_face: .
+25Hi @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!
+25Amazing! thank you so much!
If this solutions works for you, then please mark my post as “solution” so others can find it to :slightly_smiling_face: .
+21@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!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.