Date Value list displays in US while data is actually in Australian Format
Operating system version
Description of the issue
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.
Value list shows actual values from target field in format specified by system.
Value list shows actual values from target field in US format.
Exact text of any error message(s) that appear
None - other than manually entering dat in find requests.