Date format displaying incorrectly (and inconsistently)

Report a Bug
1

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
image920×1748 266 KB

IMG_1279.PNG
IMG_1279.PNG1125×2436 449 KB

image
image
image1230×294 24.6 KB

2

Hi @Phil_Jackson

Does this help?

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

3

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
image1556×256 18.3 KB

But it doesn’t elaborate!

4

Do you have the locale or region set correctly on your phone? Make sure it’s English (UK) and not English(US).

3 Likes
5

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

4 Likes
6

@Phil_Jackson nice one, it’s always the simple things @Jeff_Hager I knew it :slight_smile:

3 Likes