6 Replies Latest reply on Feb 23, 2013 9:40 PM by LaRetta

    How to script a Find by date range

    rbogdanoff

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