I have a donations file and I want the user to be able to select two dates a start date and an end date from two different fields that have drop down calendars. then when they hit search any donations that have been made between those dates will result in the search. I think i have to set the start date and end date fields as variables and run the search against the variables and the donation dates. The problem is that when i set the contrain found set in my sscript to search fro records where the donation date is greater than or equal to the variable that i created it wants a date format. But i cannot do this since the date will always be changed depending on what the user is looking for?

What should I do?

Thanks!

Erik

Make sure that start date and end date are global fields. Then:

Enter Find Mode[]

Set Field [ Donations::Date ; gStartDate & "…" & gEndDate ]

Perform Find[]

Not sure how Constrain Found Set[] comes into this.