Hi @Jenn_Salsgiver, I think we can make this work without using a date field (as that would require a year). Let’s say your storing day and month in two number fields, one for the day and one for the month (let’s call them birthDay and birthMonth). Now we can compare the day and month of
NOW() with those fields. Formula would look like this:
IF(MONTH(NOW()) = birthMonth, birthDay - DAY(NOW()), 0)
This formula gives you the difference in days between the birthDay and the today’s day of the month, but only if the month is the same.
If the result of that formula equals 7 (use a “when record matches conditions” automation trigger), send an automated email or whatever you want to do :slightly_smiling_face:
Let me know if that works!
PS: You could also make this work with only one text field for storing birthDay and birthMonth, but it would involve separating those numbers and make it more complicated.