Show list of upcoming birthdays

I found this thread, but I am not satisfied with the answer: Show Upcoming Birthdays

I want to create a list of upcoming birthdays from my users date of birth in the database.
Is it possible to manipulate the date of birth to the next birthday of the user while retrieving it in a repeating group? I do not want to store the month and day in the database, because it is information that is already available with the date of birth.

I hope someone can help me with this :slight_smile:

Is that different from just displaying the date of birth with a different date formatter on the date? One that just doesn’t show the year?

I set up a quick demo here →

This just uses a single field to filter out upcoming dates. There are 4 dates in the db, 2 passed 2 in the future, so it only shows 2. Check it out :slight_smile:

Are you trying to show the upcoming birthdays of a single user…so if my BDay is on Jan 1st it will show Jan 1, 2022 / Jan 1, 2023 etc. OR are you trying to show a list of upcoming birthdays for each user in the DB, so it is just the ‘next’ birthday of each user, so taking todays current date it could be one user shows upcoming birthday as August 22, 2021 and the next user in the RG is Jan 1, 2022 OR are you trying to show the list of upcoming birthdays in such a way that it only shows birthdays that are within the next week or month?

I’m trying to show a list of upcoming birthdays compared to the current date of all users in the database.

So today it’s Aug 3, 2021

We have three users with date of birth:
Max - Sep 30, 1997
Lewis - Jan 7, 1985
Lando - Nov 13, 1999

No I want to have a list of upcoming birthdays like so:
Next birthday:
Sep 30, 2021 - Max
Nov 13, 2021 - Lando
Jan 7, 2022 - Lewis

Screen Shot 2021-08-03 at 6.55.18 PM

That’s a big step forward indeed! Thank you very much for helping.

Unfortunately I don’t see a possibility to order the list based on the outcomes now… Is there a way?

Was not aware you wanted to order the list in any way…not sure how that can be done.