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 295
  • 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