Want to run a report based on yesterdays date 1

[tazibc]

Hi people I wonder if anyone could help???

I have created a report which I want to schedule in business objects but I want my report to only bring back data for yesterdays date automatically.

I tried to create a formula to put into the recorde selection currentdate-1 but it wont pick it up can anyone give me any suggestions on how I could acheive this without using parameters.

thanks

Taz

 

[IanWaterman]

You need to chkeck that your date field is really a Date and not a string field. If you browse field in Crystal it will tell you what its is.

There are a couple of standard Crystal functions which will convert string dates to true dates.
eg
Cdate()
DTSToDate()
DTSTo2000()

Search for Date on Crystal Help and it will show you how to use them.

In select you will then need something like

CDate(DateString) = currentdate-1

Ian

 

[dgillz]

Please post your current record selection criteria.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[lbass]

You need to explain in what way your record selection formula using currentdate-1 did not work. We don't know if you received an error message (if so, what was it?) or whether no records were returned, etc.

-LB