FTS 11, The value of this field must be a valid date...

[FranciscoMtz]

I'm using the FileMaker Training Series for FM11 advanced.

In Module 6 - Scripts, Lesson 6.4 "Using Scripts to Find Data", example 6.4.1

 

How can I set the criterion to the find request for the date field in the "Perform Find" script ??

 

The exercise says:

"Select the Date field on the left, and enter “1/1/2010...6/30/2010” as the criterion"

 

but when I click the Add button, there is a message:

"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"

 

What can I do ?

[eos]

Two reasons I can think of:

 

1) You put the date string in quotes – don't (they should have made that clear in the text!); also make sure to use periods, not the ellipsis special character.

 

2) This training manual was written using American conventions, so if your locale (System Settings / Preferences) uses the format DD/MM/YYYY (like the UK), the end date from the example is not valid. Try 1/1/2010..30/6/2010 (btw, two periods are sufficient as range operator). If you're continental European (hi there!), try DD.MM.YYYY, this should work, too.

[Lee Smith]

Are you in Find Mode?

[Lee Smith]

Here is an example of a find script

 

Go to layout                //Note: Layout out with your date field

Enter Find Mode

1/1/1013...6/30/2013   //Note: Enter the range in your date field

Perform Find                //Note: Be careful, there are two Perform Finds, you want the one that looks like this.

[FranciscoMtz]

My error was the date format, I just changed now for 01/01/2010...30/06/2010 and works

 

Thanks