2 Replies Latest reply on Jan 31, 2011 2:18 PM by philmodjunk

    Specifiying a find request by using >= in a date type

    DDab

      Title

      Specifiying a find request by using >= in a date type

      Post

      Hi

      If a table contains the field DateOfRegistration. I want to write a script that searches for all the records that have an registeration date after a specific date. The script I have written is as follows:

      Go To Layout ["Students" (Students)]

      Enter Find Mode []

      Set Field [Students::DateOfRegisteration ; "& >= 01/27/2011&"]

      Perform Find[]

      My script fails at the bolded step and I am prompted with the error, " The provided find criteria is not valid. Enter a valid request before proceeding."

      What is the correct way of specifying the value in the Set Field script step that will give me a range of dates above the specified date?

      Cheers,

      D