AnsweredAssumed Answered

Date Value list displays in US while data is actually in Australian Format

Question asked by pgageler on May 3, 2012
Latest reply on May 4, 2012 by philmodjunk

Title

Date Value list displays in US while data is actually in Australian Format

Post

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.

Outcomes