Creating Date Range using a Calculation

[Matt Leach]

Im working on scripting a report and i want to perform a find on a specific field to include a date range.

Im having some difficulties on how to perform the find to include a date range in the calculation.

Basically what i am trying to do is pull the report to include everything for the next 3 days:

Get ( CurrentDate ) ... Get ( CurrentDate ) + 3

Entering this calculation appears invalid.

What would be the proper way to calculate this?

Thanks

[Lee Smith]

Are you scripting this, or entering a range in a [color:blue]date field

Read about "[color:blue]Finding ranges of information" in the Online help

and this

Link

Lee

[Lee Smith]

You talking to me?

If not, then get in a habit of using the Reply button in the post rather than the Quick Reply Button.

[Matt Leach]

Thank you very much, it seems i always have an eye for overlooking the simplest things lol.

thanks again

[bruceR]

Yes, the calculation is invalid. You have not quoted the text string ...

This works:

Get ( CurrentDate ) & "..." & Get ( CurrentDate ) + 3

(Sorry Lee; generally I *am* in the habit of hitting reply but missed it this time)

Edited July 28, 2010 by Guest