AnsweredAssumed Answered

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

Question asked by pgageler on May 4, 2012
Latest reply on May 9, 2012 by TSGal

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.

Outcomes