Find a date range

[panache]

Hello. I'd like to script the creation of a found set that spans a given date range to be used in the printing of a report. I know that manually I could just enter find mode, go to my dateEvent field, select the greater than or equals to symbol, enter the desired start date in my dateEvent field, perform the find and then sort by dateEvent. I just don't know how to script the "greater than or equal to" a date part of the routine. I've created a "specify start date" field that I'm calling z.StartDate to hold the user's desired start date for the report. Now what? Thanks, all.

[Fitch]

Two things to note:

1. z.StartDate must be a global date field

2. your dateEvent field must be on the layout you're using for the Find -- I'll assume that you're already on this layout, but if not you can just use Go to layout in your script

Enter Find Mode

Insert Calculated Result[ dateEvent, ">=" & DateToText( z.StartDate ) ]

Perform Find