You can use the finish date field, but you'll need to trap for that date after which you are interested...
If you set up a global field (gSearchDate), enter the date in there then run a script of the form:
Enter Find Mode
SetField [FinishDateField ; ">" & gSearchDate]
You should get what you describe. The only reason the script is necessary at all is to get the < symbol into your find. Note that you could also do this manually if you prefer...depends on how you would use this function, and who. In find mode simply type in
>1/31/2011 into the finish date field and hit enter
Is this what you're after?
And a script trigger can be used to run this find automatically every time you select or enter a date in gSearchDate.
Thanks Ninja and Phil. This is exactly what i am after. I have tried to set up the search but it keeps coming up with an invalid criteria field set.
Where do i set up the gSearchDate field?
At the moment i have a layout to enter the requested date and a button to trigger the script. Once the button is triggered it goes to the a list layout that i want but enters into find mode. If i press continue it just gives me the records unsorted.
Make sure that gSearchDate is a field set up with global storage. This script will not work unless you do that. gSearchDate can be defined in any table in your database and sometimes I define a table just for global fields so I can better keep track of them.
In your script, clear the pause check box so that the script does not pause while in find mode.