Hi All,

I am preparing a report which runs on everyday 8AM morning and capture all closed data till that time.
So what I want to filter out here is closeddata from 8 am yesterday till today8 am

My closedate info resides in a table called close_date.
In select expert I am using a record selection formula like this

@closedate >= currentdatetime-1

and I scheduled the report to run on 8 am everyday so that it will capture correct data.

Now the problem is,On Mondays I need to get data from Friday 8 Am till Monday 8 AM.
For doing this I tried the below formula

If (dayofweek(currentdate)=2)
then @closedate >= currentdatetime-3
else @closedate>=currentdatetime-1

This formula is not working for me.. I am getting an error like not supported.
Ps :@closedate formula has time stamp on it

Can any gurus pls help me..I am a newbie to Crystal reports.

Thanks in advance !!



Edited by nikhil_thrissur - 10 Jan 2011 at 10:45pm