I want to send a happy birthday email at D-14 in Marketing Cloud
My problem is that I find the right clients well but I also find clients whose with a birthday date shifted by a day compared to what I want.
I created my automation the June 16th so I should have clients whose birthday is June 30th. But when I look my DE I can see clients whose birthday is June 29th.
Is it due to leap years?
In my query I used:
WHERE DATEPART(DAYOFYEAR, CTS.Birthdate) = DATEPART(DAYOFYEAR,(getUTCDate()+14))
How I can have just customers whose their birthday is in 14 days?