Crystal Report. Day of Week Function

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
Chris said:
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
Click to expand...

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;
 
Back
Top