Executing a Find Script with a range of dates as the criteria

Question

Im trying to create a Find Script on two date selection fields (Drop Down calendars) that automatically run each time the field is updated/changed (I understand this part aka script triggers) and the report will show the results that contain dates listed between the range selected.

Please Keep in mind that I'm quite new to this so please correct me where you think I could improve is you find or see anything else that appears to be wrong. Anyways, here is the Layout for my report where the selection fields and results field are highlighted.

Here is the script code I've created and I'm trying to use.

"Pre Construction::Bid Date" ≥ "Bid Date Search::Start Date" & "Pre Construction::Bid Date" ≤ "Bid Date Search::Start Date"

Here is the error I get when I try to add/save this in/under the perform find -> specify dialog box.

Ive tried and set all the fields to use the exact same date layout and format (the xx/xx/xxxx) and ive still had no luck in created this type of search. Im hoping someone will be able to help me fix this or offer other solutions as to how I could go about creating this. Thank you all

Answer 1

There are two problems with your attempt:

• First, you cannot use references to fields in a find request.
• Next, to find records within a specified range, you must use the range operator (two or three periods).

Now, you could populate variables with the range boundaries and use these in the find request instead of the fields, but it is much more convenient to skip stored find requests altogether and do simply:

Enter Find Mode [  ] 
Set Field [ Pre Construction::Bid Date; Bid Date Search::Start Date  & ".." & Bid Date Search::End Date ] 
Perform Find [  ] 

Of course, we are assuming that the Start Date and End Date fields are global fields.