If a birthday is between two dates

dominic1 · 2024-10-05T15:23:47.844Z

I have events that participants attend and on the event participant list i would like to show who has a birthday during the event.

Event dates 30/05/2025 to 05/06/2025

Participants
John 29/05/1988
Paul 01/06/1977 (show)
Lauren 05/05/2000 (show)
Jane 01/01/1999

hanan1 · 2024-10-06T07:52:02.050Z

hey @dominic!

I think it’s simple enough using the :advanced filter. You need to change the year for each user to the year where the event is happening and check whether the birthday falls within that range. Otherwise the date comparison would be off.

I assume “Lauren’s” birthday is 05/06 if it should show though, not 05/05.

If you have an event with a start date and an end date, data source for RG should be:

users:filtered:advanced: this user’s birthday:change year to:[event-start-date-extract-year]>=event start date.
users: filtered:advanced: this user’s birthday:change year to:[event-end-date-extract-year]<=event end date.

I think this should do the trick.

veronica.smith21436 · 2024-10-07T14:44:27.589Z

Sounds quite interesting