Date Value list displays in US while data is actually in Australian Format
I have converted a large database from v11 to 12. A date field is set to Australian Format (the same format as the file was originally created in) and diaplay correctly (DD/MM/YYYY). However, after conversion a value list based on that field shows the dates in US format (MM/DD/YYYY).
So while the values in the field are: 1/4/2010, 1/5/2010, 1/6/2010 ...
They appear in the drop down list as: 4/1/2010, 5/1/2010, 6/1/2010....
And selecting 4/1/2010 (for example) does not find records for 1 April 2010 - so in FIND mode the field appears to be reverting to US format, but to Australian format in BROWSE mode.
I have turned off and reindexed the field, and created a new value list - both to no avail.
[Along with speed, ESS, just one more issue that is looking like v12 is an absolute dud.]
Any help on this one would be appreciated.