I am looking for help with an age based journey. The journey has a decision split that needs the proper filter logic using the birthdate (ex. 12/21/1983) field that includes the year. The entry source is coming over from a campaign as Salesforce Data that people aging to 49-50 are entered into.
This journey is for people turning 50. Before turning 50 they start the journey at 49. If the person is months over 49 the decision split would put them on the correct decision path.
The problem is doing a date range based off of after an anniversary, with what is given as filter criteria of a decision split. You can not combine "is anniversary of" with "is on or after" that I am aware of, and the year in the birthdate field would mess with only having "is on or after."
Email 1 - Full Journey - age 49 (day of and greater than 60 days)
Email 2 - Rest of Journey - age 49.2 (greater than 60, less than 120 days)
Email 3 - Rest of Journey - age 49.4 (greater than 120 less than 180 days)
Email 4 - Birthday -
I would like to send this on the day of, I was hoping to use the "wait by attribute" activity in the journey, but anniversary is not a choice since the birthdate includes the year. If the email is not sent the day of that's ok, as long as it's ballpark because it will play off the time duration.
Email 5 - age 50.2 (2 months after email 4/Birthday).
Any ideas or suggestions would be greatly appreciated.