Hello,
I’m new to Glide and I need your help.
I would like to activate reminders for birthdays by having initially entered their date of birth.
How to convert the date of birth entered (ex: 06/05/95) into a recurring and annual birthday date (ex: 06/05/22, 06/05/23, 06/05/24…) so that the date can automatically be inserted into the calendar?
Thank you
Florence
Hi @Fleau75,
Welcome to the community
Not good with Dates but I think this should work!
All columns :
Birthday column ( Date and Time Basic column ) that user adds their birthday :
Day column ( Math column ) that gets the day of the birthday column :
Month column ( Math column ) that gets the month of the birthday column :
Now Year column ( Math column ) that gets the year of today’s date :
Date column ( Template column ) to connect Day,Month,Now Year column to make the date :
Display inside the Calendar Layout :
For test I added 365 days to the Now column and I get the 2023 year :
Just thought to tag Jeff ( @Jeff_Hager :- Master of Dates ) to know if he has a different solution and to confirm If I’m correct Not only Jeff, there are some more makers that so much better with Dates but this post might get like a spam if I tagged them all.
Thank you
Here, you can just point it to the “Now” value instead of having to create a “Now” column.
Otherwise, if the template column works in the Calendar view then I would assume that is the correct answer.
Thanks Thinh! I think I overthink-ed that part I have updated my post!
Awesome Robert! Thanks for sharing!
Extra Robert, it works!
Thank you very much, I’m so impressed with this community, it’s great to have this support.
Many many thanks !
Thank you very much Dilon for all these explanations.
For the moment, I used Robert’s method and it worked! For me who is starting and who absolutely does not know how to code at the base, this community is a great help so thank you again for all these shares.
Glad it worked!