Searching by date math

[ddreese]

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!

[RalphL]

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)

[ddreese]

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

[Lee Smith]

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,