date selection

[3dthies]

for a date field i want to have a function which automatically generates a report from yesterday.

The second thing is that whe have working times from onday to saturday. so, when i start a report on monday, it should use automatically the saturday and not the sunday.

 

[dgillz]

The formula below will pulll data from 2 days ago if the date is a Monday, otherwise it will pull from the previous day. I hope this helps.


if Dayofweek(CurrentDate) = 2 then {DateField}=Dateadd("d",-2,Currentdate) else {DateField}=Dateadd("d",-1,Currentdate)



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

http://www.trianglepartners.com

 

[3dthies]

It don't work.

the date fiel has the following structure:

yyyy/mm/dd hh:mm:ss

Maybe that is the problem?

 

[Madawc]

dgillz's formula should work. What version of Crystal? And have you used it to generate a value that you've then put in the selection formula?

Madawc Williams
East Anglia, Great Britain