Finding date ranges

[lrcarey]

I'd like to script a find to catch all records with event dates from two months back (say 60 days) through today and all future dates. I can't figure out how to set up that kind of date range.

Thanks in advance,

Leah

[CobaltSky]

If it is just a find in one file (rather than a filtered portal to another file), you can search on a range by entering both dates into the field in find mode, separated by three periods.

Thus find criteria (in mm/dd/yyyy format) of:

1/1/2001...12/31/2001

will return all dates in the year 2001.

[danjacoby]

Create a calc field that returns a "1" (or an "x") if EventDate - Status(CurrentDate) > -60. Then do a find on the calc field.

[lrcarey]

Thanks, it worked perfectly!

Leah

[RussBaker]

In my Handy Hints file in the samples section, there are several examples of how to find date ranges, showing calculations that you would use with the Insert Calculated Result script step. They're under the "Dates" tab...