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.
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?