# Date format locale struggle: sheet vs app **URL:** \ **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:** 11
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [February 6, 2022, 2:11pm UTC](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007/11 "2022-02-06T14:11:52Z")
> [@Darren\_Murphy](#): > > This is why I _never_ use the short date format in GDE Hi Darren, I’m actually working on something based on your recommendation to me [here](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176/2). I’m raising this issue here as I believe it’s a date format issue, but not 100% sure. So, here’s what I’ve done: 1. Listed all holidays in a Google Sheet (colA=start date, colB=holiday name). ColA is formatted DD/MM/YY. 2. created a bridge to my custom form sheet (using the “User email” trick). 3. Generated a Joined List for all values on the holidays sheet. 4. An ITE column is showing true if the set date (from date picker) is included in the JL column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3db3d57fb1f465ef2c372a2a7820a94a7d7d33f.png) 5. Added a hint which is (supposed to be) showing only when ITE column is “true”. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca601cbfc5fd4310a03aef174adb94decedb5e7b.png) Well…that’s not working ☹ The ITE column is actually working as planned but for some reason the hint is displaying (or not) based on some other mystery logic. I’m not sure it’s a date issue, but that seems like the most plausible culprit. Any ideas? Thanks --- _[View the full topic](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007)._