AnsweredAssumed Answered

Find records between dates in script

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

Title

Find records between dates in script

Post

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.

Outcomes