In Australia (where I live) the usual date format is dd/mm/yyyy. In the US it is usually mm/dd/yyyy.
I appreciate there are localisation options, but when selecting date as a field type, there aren't.
Can the default be the international - yyyy/mm/dd
At least then that column will sort correctly and display in date order.
Alan Singer Melbourne Australia commented
I am in Australia (as well)
... and not having the ability to localise the table storage of date field and, also enable the import to accept dates in our "native" format dd/mm/yyyy would be very beneficial.
What I must do now is reformat all the spreadsheet date fileds to US format mm/dd/yyyy