2 Replies Latest reply on Oct 13, 2009 12:38 PM by rahpe

    Find records between dates in script



      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.