7 Replies Latest reply on Jul 28, 2016 4:00 PM by JohnnyYeip

    Newbie Working through FTS 11 Date weirdness

    pareidolia.x

      I'm on chapter 6 learning about find scripts doing example 6.4.1. Step number 6 of the example says to input a date range “1/1/2010...6/30/2010”. I tried following this step but I kept getting the following invalid date format error [The value of this field must be a valid date in the range of years 1 to 4000 and should look like “12/25/2003”.]. I monkeyed around with it a while and realized that contridictory to the error message FileMaker would only accept a metric date format 2003.12.25 .

       

      Why is this happening!?

       

      Is it because as a metric system lover I have my Lion OSX set to display metric dates or is it because of a preference I set in FileMaker and forgot about. More importantly, will this effect deployment of my solutions? As a Canadian, I have to allow for my users using different date standards.