# Show date without year?

**URL:** <https://community.glideapps.com/t/show-date-without-year/28550>\
**Category:** Ask for Help\
**Created:** [July 1, 2021, 5:16am UTC](https://community.glideapps.com/t/show-date-without-year/28550 "2021-07-01T05:16:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Donny\_Lau](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/donny_lau/32/19029_2.png) [@Donny\_Lau](https://community.glideapps.com/u/Donny_Lau)\
**Post date:** [July 1, 2021, 5:16am UTC](https://community.glideapps.com/t/show-date-without-year/28550/1 "2021-07-01T05:16:39Z")

</div>

I have a sheet with the birthdays of the Members, but I intend to show only their date but not the year. Besides relying on the formula on google sheet, I wonder if it’s possible to be done in glide date editor?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 1, 2021, 5:26am UTC](https://community.glideapps.com/t/show-date-without-year/28550/2 "2021-07-01T05:26:46Z")

</div>

You can use two math columns to derive the date and the month, then combine them together in a template column the way you want.

---

<div class="post-metadata">

**Author:** ![Donny\_Lau](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/donny_lau/32/19029_2.png) [@Donny\_Lau](https://community.glideapps.com/u/Donny_Lau)\
**Post date:** [July 1, 2021, 5:36am UTC](https://community.glideapps.com/t/show-date-without-year/28550/3 "2021-07-01T05:36:44Z")

</div>

Thanks for the solution!  
I used the math column to extract the month, which give me a number, instead of January, February etc.  
If I wish to show e.g. 20 January, I believe I need to have a new sheet with the months in word, then create relation to this sheet with month in number? Or glide has something more direct?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 1, 2021, 5:51am UTC](https://community.glideapps.com/t/show-date-without-year/28550/4 "2021-07-01T05:51:58Z")

</div>

It’s not really direct, but you can either create an if then else to derive the month name, or create a new sheet as you said, only need the months in order, then a single value column, with the settings from start \> point to month value of current sheet, taking the month name back from the newly created sheet.

---

<div class="post-metadata">

**Author:** ![Donny\_Lau](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/donny_lau/32/19029_2.png) [@Donny\_Lau](https://community.glideapps.com/u/Donny_Lau)\
**Post date:** [July 1, 2021, 5:58am UTC](https://community.glideapps.com/t/show-date-without-year/28550/5 "2021-07-01T05:58:10Z")

</div>

Brilliant! Thanks 😃

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/show-date-without-year/28550/6 "2024-01-17T16:51:38Z")

</div>