Issue report
Value list dates format not usable.
Issue report posted June 22, 2012 by Ian Quinn
266 Views, 21 Comments
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.
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.
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.
Screenshot:
Answer
Hello Ian Quinn:
Thank you for posting.
Are you generating the list of dates from a field in an external file?
TSwildcat,
FileMaker Inc.
Be the first to like this
|
Sign in to "Like"
Thank you. I am using dates from onother table in the same Filemaker file. It is not an external file.
Be the first to like this
|
Sign in to "Like"
Hello Ian Quinn:
Thank you for posting.
I cannot seem to replicate this issue. If possible, could you submit a copy of your file. Check your inbox at the top of this page for instructions on how to submit your file.
TSwildcat,
FileMaker Inc.
Be the first to like this
|
Sign in to "Like"
I have recreated the problem in a new minimal file. There are two tables: Period Ends contains a date field. Records contains a date field. There is one value list which uses the dates from Period Ends. The date field in Records is a Pop-Up using the value list.
I did not attempt any formatting of any dates. There are in the default format which is DD/MM/YYYY. This applies to both filds in both tables.
When the pop-up list shows the format of that list is MM/DD/YYYY. Once a date is chosen 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.
I attach the file. Try entering a date using the pop-up menu in the Records table.
It is possible that this is a localisation issue. I imagine that this problem would not arise if the default date format were MM/DD/YYYY.
Ian Quinn
Be the first to like this
|
Sign in to "Like"
Hello Ian Quinn:
Thank you for posting.
I'm still unable to replicate this issue. Make sure you are setting your default date format for the Mac OS. You can set the default format by going to 'System Preferences' > 'Language & Text' > 'Formats'. Click the 'Customize..." button then define the desired format.
Hope that helps.
TSwildcat,
FileMaker Inc.
Be the first to like this
|
Sign in to "Like"
I have the same issue Ian. Nothing to do with system preferences. I have a date value list and the dates are popping up in North American format and are not eneterable into a normally formatted date field. Is this a FM12 bug?
Thanks, Chris Richardson
Be the first to like this
|
Sign in to "Like"
I have investigated further. I attach a file with three screen shots. I have checked my system preferences. My date preferences are for the format 31/12/2012. This is also the format of my FM12 date fields. The drop down menu which gets its dates from one of the tables displays in the format 12/31/2012. The date field cannot accept that format.
The problem goes away if I set my system preferences to the 12/31/2012 format. However the dates are then displayed in that format. This is unacceptable as all our date formats are 31/12/2012. We have previously had serious issues when someone confused 10/3/2102 with 3/10/2012.
This problem did not arise in FM11. It is clearly a bug that needs to be fixed quickly.
Be the first to like this
|
Sign in to "Like"
Be the first to like this
|
Sign in to "Like"
I have now checked it on a Windows PC. The problem is exactly the same as on a Mac. The problem did not arise when running FM11 on the PC either.
The problem applies in the same way to Drop Down Lists as to Pop Up Menus.
The following statement is propbably correct: "FM12 Pop Up Menus and Drop Down Lists using dates from another field do not function properly in FM12 except when using date formats other than US standard ones. "
Be the first to like this
|
Sign in to "Like"
Hello Ian Quinn:
I am still having trouble replicating this issue. You said previously that you attached the file. Where did you send the file?
TSwildcat,
FileMaker Inc.
Be the first to like this
|
Sign in to "Like"