# Displaying Birthdays **URL:** \ **Category:** Ask for Help\ **Created:** [March 4, 2020, 9:05am UTC](https://community.glideapps.com/t/displaying-birthdays/5139 "2020-03-04T09:05:26Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 4, 2020, 9:05am UTC](https://community.glideapps.com/t/displaying-birthdays/5139/1 "2020-03-04T09:05:26Z")
Hi there! I have a list of members of a community and I want to show a birthday calendar. Showing one’s bday on a profile page would also be nice. Maybe even an alert if it is today. There once was an app called “confetti” but I cannot find it anymore. Do you have an idea how to do this? The user will enter her birthday, but this will be saved as dateandtime. I do not want to output the time and I do not want to output the year of birth neither - it should be the actual year or sth like “in 4 weeks”. Could I do it with a math column under "data? I do not want to do excel formulas 😉 Thx Jan ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 4, 2020, 3:30pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/2 "2020-03-04T15:30:45Z")
You just need to do some spreadsheet magic. This should do the job: > **[Is today their birthday](https://docs.google.com/spreadsheets/d/1Z8FoKAx_CAcxLidhVteOaZlQdhVcTd9fMArkCpyotsE/edit?usp=sharing)** > > Sheet1 > > Name,Birthday,Birthday this year,IsToday > George,3/4/1999,3/4/2020 > Milez,3/5/2020,3/5/2020 > Somebody,1/2/1950,1/2/2020 > Else,3/4/2001,3/4/2020 > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 4, 2020, 3:52pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/3 "2020-03-04T15:52:54Z")
But glide is writing kind of this data to my cells: 1979-09-27T00:00:00.000Zz User provides 27/09/1979 via datepicker ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 4, 2020, 4:30pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/4 "2020-03-04T16:30:28Z")
Oh, to answer your question no you can’t do it with the Glide Math column yet as far as I know so you are stuck with Google Sheets for now. Just create a column in your sheet to format it the way you want it. For instance I added this to the sheet I shared: ```auto ={"Formatted nicely";ARRAYFORMULA(IF(LEN(B2:B),TEXT(B2:B,"mm/dd"),""))} ``` ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 7:12am UTC](https://community.glideapps.com/t/displaying-birthdays/5139/5 "2020-03-05T07:12:56Z")
Hi George, thank you. Maybe you can make your sheet writeable? Then I could add “my” data". My problem is the data glide writes. Your formulas do not apply there and are throwing errors. I still do not understand the way glide is writing to the sheet. How do I influence that? Can I somehow control it? Do I have to prepare the column somehow? I have to use the datepicker component, right? Why is there a timestamp written at all? I now do have 2 birthday cells with 2 different data written from testing: 1979-09-27T00:00:00.000Z and 27.09.1979 I do not know how this happened 🙂 Jan ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 5, 2020, 12:20pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/6 "2020-03-05T12:20:26Z")
Both are dates in the sheet, they are just formatted differently. I wouldn’t worry about it as you should format them in a different column as you want using the TEXT() function. If you only want the Month and Year, why not just ask for that. Here is a little app I created that shows you both ways. I set it up as a template so you can make a copy. [birthday.glideapp.io](http://birthday.glideapp.io) ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 4:49pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/7 "2020-03-05T16:49:50Z")
Thanks! This works and I will be able to copy it. But I still do not understand how the date component is behaving… I also want to make a calendar tab with upcoming birthday (using your birthday this year column), then glide puts a time of “12:00”. Seems that it is not possible to use date component without time? Jan ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 5, 2020, 6:02pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/8 "2020-03-05T18:02:28Z")
I would venture to say that any system that stores dates stores them as a datetime object. If only a date is supplied then the time is set to 00:00:00 which is 12AM or 00:00. That is the way they are stored in a Google sheet as well. The calendar view is designed for events with a time attached. It shows the day and then any events for that day. The time that is shown can not be suppressed. So for your own calendar view just create another Tab page that points to the Sheet1 but sorts on the Birthday a list view that is sorted by “Birthday this year” column. You can display whatever info you want to make it look like a calendar view. I did this in the sample app to give you an idea. ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 6:51pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/9 "2020-03-05T18:51:35Z")
George, thanks a lot! One last question: would it make sense to have all birthdays in a separate sheet and build a relation? Jan ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 5, 2020, 6:57pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/10 "2020-03-05T18:57:30Z")
I wouldn’t think so. Since people only have one birthday then all you need is an extra column in there row of other profile info. Relations mostly only make sense if there are more than one. There is a place for one to one relations but for me that has to do with the ability to have two different detail view screens pointing to somewhat of the same data that potentially allow editing of different areas of the data. A little hard to explain but as a general rule relations make more sense when it’s one to many. Also if you make a relation just for birthdays you double the row count which brings you to needing a Pro version twice as fast. ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 7:00pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/11 "2020-03-05T19:00:26Z")
Hi ok thanx. I am not able to copy your formulas to my existing sheet, they still throw an “Formula parse error.” And glide is again writing the strange timestamp format into the sheet: 1979-09-28T00:00:00.000Z Your example is not doing this Jan ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 5, 2020, 7:09pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/12 "2020-03-05T19:09:07Z")
Format that entire column as a more friendly Date format like mm/dd/yyyy. Does that work? This would be done by clicking the entire column in the sheet, then Format/Number/. pick a date format. ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 7:11pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/13 "2020-03-05T19:11:07Z")
Yes, that works. If I try the data in your example it works very well, too. I am just not able to copy the formula to my sheet - somehow it breaks, but I cannot debug it. Even if I copy the formula back and forth - it still works in the original sheet, but not in mine. Is there any chance to get a better error description? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2020, 7:19pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/14 "2020-03-05T19:19:16Z")
You might have to alter the formula a bit, so it is pointing to the correct column. For example, change B2:B to whatever column has your date. ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 7:22pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/15 "2020-03-05T19:22:08Z")
Yes sure! Copying to a new sheet also works, but it is not possible to copy it to my existing app sheet. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2020, 7:25pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/16 "2020-03-05T19:25:41Z")
Can you take a screenshot of your Google sheet with the formula showing in the formula bar? Also make sure the column cells below your formula are empty. ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 5, 2020, 7:28pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/17 "2020-03-05T19:28:07Z")
![Bildschirmfoto 2020-03-05 um 20.27.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c39d6573b747b2e05dfb14e8da5ef61e360d5bbb.png) yes, thanx for taking a look! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2020, 7:39pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/18 "2020-03-05T19:39:34Z")
I wonder if this is a regional thing. Some countries use semicolons instead of commas. I don’t know how that works with the column heading though. Change commas to semicolons and semicolons to commas. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 5, 2020, 7:47pm UTC](https://community.glideapps.com/t/displaying-birthdays/5139/19 "2020-03-05T19:47:07Z")
What country is your spreadsheet set to? Some countries expect ; (semi colon) separators instead of , (comma) separators. File/Spreadsheet Settings Locale ---
**Author:** ![milez](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@milez](https://community.glideapps.com/u/milez)\ **Post date:** [March 6, 2020, 9:19am UTC](https://community.glideapps.com/t/displaying-birthdays/5139/20 "2020-03-06T09:19:10Z")
Hi! Now it works - I had to change “,” to “;” - my locale is set to Germany. Thx a lot!! Jan [Next page](https://community.glideapps.com/t/displaying-birthdays/5139.md?page=2)