5 Replies Latest reply on May 10, 2012 8:10 AM by TSGal

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

    pgageler

      Summary

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

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Windows 7

      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.

      Expected result

      Value list shows actual values from target field in format specified by system.

      Actual result

      Value list shows actual values from target field in US format.

      Exact text of any error message(s) that appear

      Not Applicable.

      Workaround

      None - other than manually entering dat in find requests.