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??