5 Replies Latest reply on May 2, 2011 9:31 AM by LaRetta_1

    Trying to omit records with a certain date range in a script - need help

    macguy918_1

      Title

      Trying to omit records with a certain date range in a script - need help

      Post

      I have a timestamp field in a database and I want to use a script to do a find and then omit records in a certain date range.

      I am trying to do it as follows:

      Enter Find Mode []

      Set Field [Tablename::Fieldname, "11/04/2010..." & Get(CurrentDate) -7"]

      Constrain Found Set []

      This is not working, and I don't know why...

      Any ideas about what I am doing wrong?

      thanks