Search code examples
phpapifilemaker

Filemaker returns error 500 (Date value does not meet validation entry options)


I'm using Filemaker ( which I'm not super familiar with ) and it's returning error 500, which means according to the docs:

Date value does not meet validation entry options

I'm passing the following date format ( as a string ):

string(10) "25/09/1988"

This is the error that is returned.

object(FileMaker_Error)#134 (9) {
["_fm"]=>
&object(FileMaker_Implementation)#3 (3) {
  ["V73ee434e"]=>
  array(9) {
    ["charset"]=>
    string(5) "UTF-8"
    ["locale"]=>
    string(2) "en"
    ["logLevel"]=>
    int(3)
    ["hostspec"]=>
    string(12) "81.83.29.158"
    ["recordClass"]=>
    string(16) "FileMaker_Record"
    ["prevalidate"]=>
    bool(false)
    ["database"]=>
    string(19) "administratie.fmp12"
    ["username"]=>
    string(11) "blankedout"
    ["password"]=>
    string(11) "blankedout"
  }
  ["Vea4b3413"]=>
  NULL
  ["V9a3dcbce"]=>
  NULL
}
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
string(3) "500"
["message"]=>
NULL
["userinfo"]=>
NULL
["backtrace"]=>
array(6) {
  [0]=>
  array(7) {
    ["file"]=>
    string(62) "/data/sites/web/babydealtoday/www/includes/FileMaker/Error.php"
    ["line"]=>
    int(52)
    ["function"]=>
    string(10) "PEAR_Error"
    ["class"]=>
    string(10) "PEAR_Error"
    ["object"]=>
    *RECURSION*
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(2) {
      [0]=>
      NULL
      [1]=>
      string(3) "500"
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(90) "/data/sites/web/babydealtoday/www/includes/FileMaker/Implementation/Parser/FMResultSet.php"
    ["line"]=>
    int(48)
    ["function"]=>
    string(15) "FileMaker_Error"
    ["class"]=>
    string(15) "FileMaker_Error"
    ["object"]=>
    *RECURSION*
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      &object(FileMaker_Implementation)#3 (3) {
        ["V73ee434e"]=>
        array(9) {
          ["charset"]=>
          string(5) "UTF-8"
          ["locale"]=>
          string(2) "en"
          ["logLevel"]=>
          int(3)
          ["hostspec"]=>
          string(12) "81.83.29.158"
          ["recordClass"]=>
          string(16) "FileMaker_Record"
          ["prevalidate"]=>
          bool(false)
          ["database"]=>
          string(19) "administratie.fmp12"
          ["username"]=>
          string(11) "blankedout"
          ["password"]=>
          string(11) "blankedout"
        }
        ["Vea4b3413"]=>
        NULL
        ["V9a3dcbce"]=>
        NULL
      }
      [1]=>
      NULL
      [2]=>
      string(3) "500"
    }
  }

This is the field in the Filemaker Software itself

enter image description here


Solution

  • Try entering that same date string in using FM Pro and see if you get an error. It is likely that the OS is not set to use the proper date format, if the default is set to the US standard MM/DD/YYYY. FileMaker uses the date format that is configured at the system level.