1 2 Previous Next 21 Replies Latest reply on Jul 16, 2012 4:35 AM by ian.quinn

    Value list dates format not usable.

    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

        1 2 Previous Next