How to script a Find by date range

Discussion created by rbogdanoff on Feb 23, 2013
Latest reply on Feb 23, 2013 by LaRetta

I have a global field called YEAR. User enters year. Two global fields then calculate the start and end date range. So if user enters 2011 in year filed, the YearRangeStart is populated with "1/1/2011" and the YearRangeEnd field is populated with "12/31/2011". The FM knowledgebase then says write a script like this:


Enter Find Mode [ ]

Set Field [myTable::ADateField ; myTable::YearStartDate & "..." & myTable::YearEndDate]

Perform Find [ ]


When I run this script it says the Find criteria is not valid. What is wrong with this script??