day of week function

[Ken Langendock]

Here is a sample defined item that should answer your
question

DEFINE D_DOW CHAR*9 = &
        "Monday" IF 1 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Tuesday" IF 2 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Wednesday" IF 3 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Thursday" IF 4 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Friday" IF 5 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Saturday" IF 6 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Sunday" IF 0 = MOD(DAYS(EFF_DATE),7)

Ken

 --- Viet Nguyen <VNguyen@wsboces.org> wrote: 
> Please can someone tell me how to get  day of week
> (Monday, Tuesday )
> from sysdate . I looked at dateextract but it
> doesn't allow for this
> option.
> 
> Thanks
> 
> Viet.
> 
>  
> 
>