Good evening. I am having some issue with dat...

(William Stewart) #1

Good evening. I am having some issue with date formats. I want dd/mm/yyyy. Have Sheets locale set to Australia (as New Zealand still not an option).

Also have Doc set to English / UK for my reports. In Appsheet it has automatically detected Australia as locale, however I get invalid date if I try to

do DD/MM and so am still having to do MM/DD. Any other suggestions?? Should I set Sheets to UK also??

Thanks

(William Stewart) #2

Reposting with Bug tag - when set on UK format, if I do 01/04/2018 it is setting it to January 4, 2018…