AnsweredAssumed Answered

Find records between dates in script

Question asked by rahpe on Oct 13, 2009
Latest reply on Oct 13, 2009 by rahpe


Find records between dates in script


I have written a script to set 2 global date fields: "Start Date" and "End Date" in a Table called Report Dates.

Now I want to find records in other tables  where the "Date" field falls in the range of "Start Date"..."End Date"


  1. I go to a layout in the other table, call it Purchases
  2. Showing all records
  3. Entering "Find" mode
  4. Then I am trying to Set Field "Date" to the desired range
  5. Then Perform Find


I cannot come up with an acceptable format for the above bold step. If I try the Find manually it works if I type 1/1/09...1/31/99



I'd appreciate some suggestions.