Hi Everyone - I decided to test the CSV import action, so I can import bank transactions into an app. Appsheet transposes the day and month of short date formats. I’m in the UK, so it’s DD/MM/YYYY. I imported from an Excel CSV with locale set as UK, in Chrome browser with locale set as UK into Appsheet with locale set as UK. After the import, Appsheet had transposed DD and MM for any dates with a day value =< 12 and ignored any others.
I downloaded a simple CSV from Google drive to rule out Excel. Appsheet did exactly the same.
I then changed the date format in the Google CSV to “DD MonthName YYYY”. Appsheet imported this fine, with no transposition.
I did the same date format change for the Excel CSV and Appsheet imported this fine, with no transposition.
It seems as though Appsheet gets confused by the short date format and ignores locale.
Can anyone help with this?