Date Format Locale Issues...again

After trawling through this forum i still cannot solve.

  1. My Locale is English/UK in Google Sheets
  2. United Kingdom is set in the Table’s Locale within Appsheet.
  3. The table Data in Appsheet reads correctly.

Yet my dates in the App insist on displaying "12/31/2020

What am i missing?

Cheers, Tris

Solved Solved
0 4 288
  • UX
1 ACCEPTED SOLUTION

Thank you Lynn you’re a star.

In Chrome the solution is:

  1. Setttings > Advanced > Langauge > Add Language > “English (United Kingdom)” > Add
  2. English (United Kingdom) > Display Google Chrome in this language
  3. Restart Browser

Having “English” alone was not enough.

That has now switched round one of the dates in my app but i’m sure that’s down to the code for my virtual column.

Thanks again.

Tris

View solution in original post

4 REPLIES 4

To Clarify, What i’m after is a global DDMMYYYY format.

Hi @Tristan_Bennett
Have you checked the settings on your device/ browser?

Thank you Lynn you’re a star.

In Chrome the solution is:

  1. Setttings > Advanced > Langauge > Add Language > “English (United Kingdom)” > Add
  2. English (United Kingdom) > Display Google Chrome in this language
  3. Restart Browser

Having “English” alone was not enough.

That has now switched round one of the dates in my app but i’m sure that’s down to the code for my virtual column.

Thanks again.

Tris

@Tristan_Bennett
Great, could you mark the post as solved

Top Labels in this Space