Help

Add a date reminder

Topic Labels: Automations
Solved
Jump to Solution
1972 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Liran_hamburg
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Screenshot (2)

Help please :pray: :pray: :pray:
Thank you!
Liran

1 Solution

Accepted Solutions

@Liran_hamburg

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

See Solution in Thread

4 Replies 4

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!

@Liran_hamburg

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

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