Date Parameter

[CIBS]

Hi

I am using CR9

I want to use a parameter so the end user selects a date fot the report (This is done and easy) what I want it to do is the user select the date normally the current date and the report automatically does it for the day before

for example

the user puts in 01/02/09
the report runs for day 31/01/09

the reason I want this as I know I could just get the user to put in the day before, but this procedure may become automated once the report is up and running with no problems

thanks for any help

Stephen

 

[IanWaterman]

In your select expert statement simply change

{Datefield} = {?DateParam}-1

Ian

 

[CIBS]

Cheers this works a treat, I just have a small problem that I didn't take into account.

the report wants to pull all previous dates as well

Kind Regards

Stephen

 

[IanWaterman]

OK use <=

{Datefield} <= {?DateParam}-1

Ian