Find out Crystal Day?

[leightur]

What I want to find out, how to get Crystal to output the current day - if today = Friday then currentdate + 4 else currentdate+2

I have a the following formula:

{ESTJOB.DUE_DATE} in {@Deliveries from date} to {@Deliveries to date}

{@Deliveries from date} - currentdate
{@Deliveries to date} - currentdate+2

 

[leightur]

I have also tried this, but did not work :-(

//If DayOfWeek({ESTJOB.DUE_DATE}) = 6 Then
//currentdate + 4
//Else currentdate + 1

 

[lbass]

Try the following for a selection formula:

(
(
dayofweek(currentdate) = 6 and
{ESTJOB.DUE_DATE} in currentdate to currentdate + 4
) or
{ESTJOB.DUE_DATE} in currentdate to currentdate + 2
)

Or you could just change your end formula to:

If DayOfWeek(currentdate) = 6 Then
currentdate + 4 Else
currentdate + 2

These formulas only accommodate Fridays though.

-LB