Changing date to last work day (M - F)

[TEM3]

I have a report that displays activities for the current day, the current week to day, month to day and year to day. I am planning to add "previous (work) day". I would like currentdate to convert to a the previous Friday's date if the report is run on a Saturday or Sunday (and also, when I add, currentdate-1 convert if it is a Saturday or Sunday).

What would be a good conversion formula to use to convert currentdate to a workday??

 

[TEM3]

Sorry, forgot: Crystal Reports 8.5 and Oracle Tables.

 

[lbass]

Try something like:

if dayofweek(currentdate) in 3 to 7 then
{table.date} = currentdate-1 else
if dayofweek(currentdate) = 1 then
{table.date} = currentdate-2 else
if dayofweek(currentdate) = 2 then
{table.date} = currentdate-3

-LB