Good evening. I am having some issue with date formats. I want dd/mm/yyyy. Have Sheets locale set to United Kingdom (as New Zealand still not an option).
Also have Doc set to English / UK for my reports. In Appsheet it has automatically detected UK 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?? If the day is greater than 12 it knows which order to set it in eg. 31/03/2018 is March 31, 2018 in longdate format. But if it can’t tell which is the day vs month e.g. 01/04/2018 it reverts to MM/DD/YYYY i.e January 4, 2018