Today + 2

[drinker]

What would the formula be to show all Customer Desired Shipped Dates from curent date and everything up to two days out? Thank You.

{CUSTOMER_ORDER.DESIRED_SHIP_DATE}

 

[Madawc]

In selection,

{CUSTOMER_ORDER.DESIRED_SHIP_DATE} in [currentdate to currentdate+2]

This is for Crystal 10. There is also DateAdd for more complex operations, but +2 for a date is assumed to be plus two days

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[dgillz]

You did not state your crystal version, which can affect the answer. However in crystal 8 and newer, in the record selection formula try this:

{CUSTOMER_ORDER.DESIRED_SHIP_DATE} in CurrentDate to Dateadd("d",2,CurrentDate)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[drinker]

Thanks! Currently, using this formula my report shows only current date , but I,m sure this is what I need. I am using Crystal 8.5.