Change date format from US MM/DD/YYYY to UK DD/MM/YYYY

AppSheet AppSheet Q&A
1

Please can you provide advice on how to change the date format from US MM/DD/YYYY to UK DD/MM/YYYY. I have followed these steps below and it is still not working.

  1. From the Google Sheets select File, settings. In the Settings dialog, set Locale to UK.

  2. From the appsheet select data - table - Localization set to the UK.

2

TEXT([DATECOLUMN], “DD/MM/YYY”)

3

Change the locale settings of the device or browser.

3 Likes
4
Locale support in AppSheet - AppSheet Help
5

Hi, can you be a little more specific about how to do this please? I am experiencing the same issue with wrong formatting of dates. Thanks.