Need a variable to run report for today + 60 days...

[arachnoid]

What are some options for accomplishing this?

The report is an open order report where they are wanting to see the orders for 60 days out.

Can this be done by declaring a variable? If so, could you post an example

Thank you in advance.

 

[Naith]

You don't need a variable. It's much simpler.

In your Record Selection, you're aiming for something like this:

{Orders.Date} in CurrentDate to CurrentDate+60

Naith

 

[arachnoid]

My biggest issue is that I am working with 6 digit Julian dates and that method would require yearly maintenance.

Thanks for your reply.

 

[Naith]

Why?

I wouldn't have thought yearly maintenance would come into it at all.

e.g. 2452628.5 + 21 = 2452649.5

just like

20/21/02 + 21 = 10/01/03

If you need to convert your dates so you've got something easier to work with, go to

http://support.crystaldecisions.com/downloads/

and download UFLJUL.EXE, giving you access to the JulianToDate
and DateToJulian functions.

Naith