Help

Birthday Formula & Automation

Topic Labels: Formulas
192 2
cancel
Showing results for 
Search instead for 
Did you mean: 
LenaG
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! I have checked out the the community for an solution to my problem and can't find what I am looking for to help me with my formula and automation. I am trying to set-up an automatic alert announcing someone's birthday on the day of their birthday. It did work but it sent the announcement the day before as well as on the day of the persons birthday.

This is my formula: 

DATETIME_FORMAT({🎂 Birthday}, "MMDD") = DATETIME_FORMAT(TODAY(), "MMDD")
 
My automation is set up for when a record updates, it sends an email on the day of the persons birthday. However, it sent an email the day before and the day of.

I only need it on the day of the actual birthday. Can someone tell me where did I go wrong?

Thanks in advance.
2 Replies 2

That's...weird.  I can't see why the record would update itself twice given that formula

Maybe try using IS_SAME() and see if the same issue occurs?  Sorry I can't be of more help!

Thanks for your reply, I will give it a try and see how it plays out. Stay tuned.....