Crystal Report. Day of Week Function

[Chris]

I need to create a group to use in a cross tab report that
takes Sat and Sun and groups it with Friday so that the
values that fall into the Sat and Sun catagory are added
to Fridays values.

This is what I have so far and cannot get it to work.

if dayofweek(cdate
({_VWDATA_WorkQueueAll.Loan_Close_Date})) in [6,7,1] then
minimum(cdate({_VWDATA_WorkQueueAll.Loan_Close_Date}))

Thanks for your help

 

[MyndPhlyp]

I need to create a group to use in a cross tab report that
takes Sat and Sun and groups it with Friday so that the
values that fall into the Sat and Sun catagory are added
to Fridays values.

This is what I have so far and cannot get it to work.

if dayofweek(cdate
({_VWDATA_WorkQueueAll.Loan_Close_Date})) in [6,7,1] then
minimum(cdate({_VWDATA_WorkQueueAll.Loan_Close_Date}))

Thanks for your help

This isn't a Crystal Reports forum, but ...

Assuming Loan_Close_Date is a valid date format that CDate can convert to a
Date value, maybe what you want is more in the line of:



numberVar day_of_week :=
DayOfWeek(CDate{_VWDATA_WorkQueueAll.Loan_Close_Date}));

If day_of_week In [1, 6, 7] Then
day_of_week := 6;