# Date format locale struggle: sheet vs app **URL:** https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007 **Category:** Ask for Help **Created:** [March 9, 2021, 4:04pm UTC](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007 "2021-03-09T16:04:33Z") **Posts on this page:** 1 **Showing post:** 14
### 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: [February 6, 2022, 3:14pm UTC](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007/14 "2022-02-06T15:14:43Z")
Another alternative. I would simplify things by converting dates to a simple number with a math column and use those numbers to build relations linking the date number to the date number in the holiday sheet like @Darren_Murphy described. That way you have full control of the format and it’s completely stable without having to worry about different regional formatting. I explain it in the thread below. Only show the hint component if the relation is not empty. You should only need a math column and a relation column in addition to the date columns you already have. > [@Agent for information](https://community.glideapps.com/t/agent-for-information/29981/85): > > I’m not following these date related threads very closely, so I’m not fully clear on what the issue is. I apologize if I’m way off track on this, but couldn’t you do a math column to make a numeric column in the format of YYYYMMDD, and then split that in the code and/or convert it to a valid date? If it’s for sorting, you wouldn’t even need to convert it to a valid date since the number would sort properly as a number or as a string. With this, there wouldn’t be a need to worry about the regi… --- _[View the full topic](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007)._