Using DAYOFWEEK Function ??

[tlbrown88]

I'm not sure if using DAYOFWEEK is what I need but I am trying to exclude Sat and Sun from a calculation. I want to be able to look at a date and return a value of 2 days prior less the Sat and Sun. It would look something like this
Monday 6/27/2011 would read Thursday 6/23/2011.
Any help would be appreciated.

 

[FireGeek21]

Try this statement:

IF DayOfWeek(CurrentDate) = 1 //For Sunday
Then CurrentDate - 3 ELSE
IF DayOfWeek(CurrentDate) = 2 //For Monday
THEN CurrentDate - 4 ELSE
IF DayOfWeek(CurrentDate) = 3 //For Tuesday
THEN CurrentDate - 4 ELSE
CurrentDate - 2




FireGeek
(currently using Crystal Reports XI with Lawson 9.01)

 

[tlbrown88]

Worked perfectly! Thanks so much! Ü