AnsweredAssumed Answered

Newbie Working through FTS 11 Date weirdness

Question asked by pareidolia.x on Aug 3, 2012
Latest reply on Jul 28, 2016 by JohnnyYeip

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.