AnsweredAssumed Answered

Value list dates format not usable.

Question asked by ian.quinn on Jun 22, 2012
Latest reply on Jul 16, 2012 by ian.quinn

Summary

Value list dates format not usable.

Product

FileMaker Pro

Version

12.0V1

Operating system version

Mac OSX 10.7.4

Description of the issue

I have a table in which period end dates are entered.  They are entered in the format 31/12/2011.

A value list uses these dates for a pop up menu.  They appear in the value list in the format 13/31/2011.   They cannot be entered into a date field.  The message " The value of this field must be a valid date on the range 1 to 4000 and should look like 25/12/2003 " appears.  

The value list cannot be used.  

This bug appeared only after conversion to FM12.  It worked perfectly with FM11.

Steps to reproduce the problem

Created a table with dates using the 31/12/2011 format.
Create a value list using those dates.
Use that value list for a pop up menu of dates to enter in another date field.  The value list will show the format 12/31/2011 which will not be accepted.

Expected result

The date chosen from the value list is entered.

Actual result

an error message is generated:    " The value of this field must be a valid date on the range 1 to 4000 and should look like 25/12/2003 "

Exact text of any error message(s) that appear

" The value of this field must be a valid date on the range 1 to 4000 and should look like 25/12/2003 "

Configuration information

This bug did not appear in FM11.

Workaround

Key in the date to the expected format.  The problem is that a date which not on the 'Period end dates' may be used.

Date_fromat.png

Outcomes