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.
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:
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 ?