Searching By Date Range
I have a database which includes several employees who need quartly evaluations. How can i search for evaluations between a certain date range. (ie dec 08 through Feb 09)
Use this when searching in the field used to store the evaluation date:
let me clarify, I want to put a button on the page that enters find mode and allows the end user to enter the dates they would like to search for... SOrry I didn't say that earlier.
Etripoli's suggestion can do exactly that.
If you want to avoid requiring users to use the date1...date2 format, do this:
Define two global datefields: gDate1, gDate2.
Put them on a layout with a "find" button next to them.
Set your script up to do the following:
Go To layout [Specify a layout that works]
Enter find mode 
Set field [Yourtable::YourDatefield ; gDate1 & "..." & gDate2]
Set error capture [on]
Set error capture [off]
Retrieving data ...