# Date format displaying incorrectly (and inconsistently) **URL:** \ **Category:** Report a Bug\ **Created:** [November 27, 2020, 7:30am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993 "2020-11-27T07:30:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 27, 2020, 7:30am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993/1 "2020-11-27T07:30:11Z")
Hi, I’m in the UK so trying to get all date formats displaying as DD-MM-YY. If I look at my app in Glide app builder it displays correctly however when I look at it on my phone it is displaying as MM-DD-YY. Both my computer and phone are set to the correct time zone. The component being used is the date/time picker. Is this an error by me or a bug? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec408cb1a41eebac14ec22a2b50dbf6b2f6054b2.jpeg) ![IMG_1279.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1891c80327ece9d0c1c1d46387f24af9d4f747bd.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/689bca94098c175fcb0bf24f34d4b87b3f721641.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/59fb11a73e2bebb11e320b0127393f2a8ec60c13.png) ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 27, 2020, 8:15am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993/2 "2020-11-27T08:15:17Z")
Hi @Phil_Jackson Does this help? [https://docs.glideapps.com/all/reference/using-sheets/sheets-faq/date-and-time-formats-google-sheets](https://docs.glideapps.com/all/reference/using-sheets/sheets-faq/date-and-time-formats-google-sheets) Or [https://docs.glideapps.com/all/reference/data-editor/basic-columns/date-time-formats](https://docs.glideapps.com/all/reference/data-editor/basic-columns/date-time-formats) ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 27, 2020, 8:33am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993/3 "2020-11-27T08:33:34Z")
Thanks but it doesn’t. The date picker columns are glide sheet created so don’t appear in the Google Sheet. I’ve checked my Google Sheet date settings which are correct. The second link does say: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d2147b774e3afd48050e4f183bc1947cb9d6053.png) But it doesn’t elaborate! ---
**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:** [November 27, 2020, 8:55am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993/4 "2020-11-27T08:55:55Z")
Do you have the locale or region set correctly on your phone? Make sure it’s English (UK) and not English(US). ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 27, 2020, 9:13am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993/5 "2020-11-27T09:13:59Z")
Ah ha. I had previously checked the time zone setting to see if it was that but I didn’t check the language and region setting so I have made sure that was set to English (UK) rather than English - sorted. Thanks ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 27, 2020, 9:42am UTC](https://community.glideapps.com/t/date-format-displaying-incorrectly-and-inconsistently/18993/6 "2020-11-27T09:42:15Z")
@Phil_Jackson nice one, it’s always the simple things @Jeff_Hager I knew it 🙂