I would like a way to calculate the date 60 days from the current date so I can do a date range search on a specific field.

For instance, if we used today as an example, I'd want it to fill in a field in search mode:

11/15/2004..1/15/2005 (or whatever 60 days from now is)

I've never done any sort of date math before, so I'm hoping it's an quick and easy solution.

Thanks!

In your script use the following step after entering the find mode:

Insert calculated result [ Date to text (Status (Current date)) & "..." & Date to text (Status (Current date) + 60)

Awesome, Ralph, thanks! I wasn't sure how that worked I'll give that a shot, thank you!

Hi Ralph, and dd,

I'll echo what Ralph has said, but I thought you might want a little more of the script.

Try this:

Show All Records

Enter Find Mode []

Insert Calculated Result [select,