Hi
I have a problem with a Dashboard where the date displays incorrectly in dd/mm/yyyy format. The date displays correctly in other areas of the App and in the source Google Sheets.
The problem occurs when I edit the date in the Dashboard table - It only accepts dates in mm/dd/yyyy format. An error message says โIncorrect Formatโ when dd/mm/yyyy is entered.
If I edit the date in the AppSheet emulator using the date Picker for the same Form - it works fine. The date e.g. 28/8/2020 is displayed in the dashboard when I refresh but can be edited to dd/mm/yyy.
I have checked my PC regional settings, Google Sheet settings, Chrome Language settings and they are all set to local UK/Ireland settings.
Can anyone suggest a way to fix this.
Thank you.
LinkedIn
Twitter
