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 ?

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.

Are you in Find Mode?

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.

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

 

Thanks