day of week function

[Darren Reely]

I like that. In fact it is nearly the example in the Cognos documention.

But it doesn't work as written below. At least on PH 8.23.D7 or 8.43.D 
on Solaris. The MOD function can't be placed there. Instead a separate 
define is needed for that. Such as;

DEFINE DAY_NUMBER integer = MOD( DAYS( SYSDATE ), 7 )
Define d_dow Character *9 &
      = Case Of DAY_NUMBER &
      ...


Darren


Robert Mills wrote:
> I use this define. Was told that it's quicker as the mod and days functions are only invoked once each. I also think that it looks neater ;)
> 
> Define d_dow Character *9 &
>      = Case Of Mod(Days(EFF_DATE),7) &
>          When 0 : "Sunday" &
>          When 1 : "Monday" &
>          When 2 : "Tuesday" &
>          When 3 : "Wednesday" &
>          When 4 : "Thursday" &
>          When 5 : "Friday" &
>          When 6 : "Saturday"
> 
> regards,
> 
> Robert W.Mills