Locale Settings: Incorrect Date Format

[Luis_DfG]

Hello,

I think I have followed all the instructions but I cannot get this to work.

A date field it’s being shown with a dd/MM/yyyy format, although the Spreadsheet it’s in a MM/dd/yyyy format.

Here is the spreadsheet locale settings.
It’s in the US, and we can see that the date it’s being saved correctly (MM/dd/yyyy)

Here is the table locale settings

When I use the date field ([Treasury Forecasted Payment Date]) in a CONCATENATE function, it shows the right format, BUT, when I show in the table content, the format changes.

Any ideas what can I check to make the date in the table follow the right format?

Thanks!

[WillowMobileSys · Accepted solution]

Luis_DfG:

Any ideas what can I check to make the date in the table follow the right format?

1. Confirm the column is actually defined as a Date.
2. Check the Locale settings for the browser itself. Because the AppSheet Editor is browser based it will pick up locale settings from there.

[Luis_DfG]

Thanks! It was indeed related to the browser locale settings.
Had to move English on top