Birthdays repeat every year, so we need to figure out this year's birthday date.
If their birthday already happened this year → we look at next year's birthday
If their birthday hasn't happened yet → we use this year's date
Special case for Feb 29 babies: If it's not a leap year, we treat their birthday as Feb 28
Look for Classes in the "Birthday Window"
We check if they have any upcoming classes within 7 days before or after their birthday.
For example, if someone's birthday is January 15th:
We look for classes between January 8th and January 22nd
Pick the Closest One
If they have multiple classes in that window, we pick the one that lands closest to the actual birthday.
Example:
Birthday: January 15th
Class A: January 10th (5 days away)
Class B: January 14th (1 day away) ← This one wins!
Class C: January 20th (5 days away)
The Difference Between the Two Reports
Report | What We're Looking For |
Instructors Birthdays | Classes the instructor is teaching near their birthday |
Clients Celebrations | Classes the client has signed up for near their birthday |