Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 07, 2021 10:19 PM
new to the program and I’m trying to trigger an automation to run 30 days prior to a date (birthday) in order to send a postcard. I’ve set the to trigger when “record matches condition” and the condition to birthday (date field) is one month from today. It will only trigger when the year matches 2021 (one month from today) Do I have to strip out the year from the birthday field in order for it to trigger?
Solved! Go to Solution.
Jan 08, 2021 09:20 AM
Thank you…that worked perfectly (for 2021) will that continue to work with each new year?
Jan 08, 2021 12:23 AM
I am not sure of the wording for this but in this example I used :
I would create another Formula Field like “Birthday” containing :
DATETIME_PARSE(DATETIME_FORMAT(Birthdate, "DD-MM"), "DD-MM")
It takes your original Birthdate (with the original birthyear), print only the Day (DD) and Month (MM)
Then, pass it to DATETIME_PARSE
that try to convert a string to a Date.
In this case, there is a missing year so he fills the year with current year.
Then your date filter shoud work :winking_face:
Florian
Jan 08, 2021 09:20 AM
Thank you…that worked perfectly (for 2021) will that continue to work with each new year?
Jan 08, 2021 09:34 AM
Actually, it just strips out the “year” from the date so, I don’t see any reason why it would stop working.
On January 1st, all formula will be “re-calculated” and will now output DD-MM of the birthdate + current year (because the real birthdate year is “missing” due to our DATETIME_FORMAT that strips it out)
@Mark_Taylor1, may I ask you to mark my previous reply as the solution ?
Florian
Jan 08, 2021 10:28 AM
Absolutely (solution marked)…so now what happens for January birthdays? the automation looks at “dates” “one month from now” for the trigger(?) When we hit December won’t all the January birthdays still be 2021?
thank you very much for the help!