1 Reply Latest reply on May 4, 2012 12:14 PM by philmodjunk

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

    pgageler

      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.