Value list dates format not usable.
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.
The date chosen from the value list is entered.
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 "
This bug did not appear in FM11.
Key in the date to the expected format. The problem is that a date which not on the 'Period end dates' may be used.