At the very beginning for a report I capture the Current Date using the code:
-SET &SDATE=&MDYY;

What I am trying to figure out is how to determine the day of the week from the current date and assign that value to a variable (numeric format).

This message has been edited. Last edited by: Jeff_Rowland,

Hint: Look up the DOWK function and the DECODE function. Post your solution.

I needed that a few weeks ago, came up with this:

 -SET &DOW = IMOD(YMD(18991231,&YYMD),7,'I5'); 

Thanks. It works for me

  
-SET &Day = DOWK(&YYMD,'A3');
-SET &DayNumber = DECODE &Day ('SUN' 1 'MON' 2 'TUE' 3 'WED' 4 'THU' 5 'FRI' 6 'SAT' 7);

-TYPE Day = &Day
-TYPE DayNumber = &DayNumber

Another 'hidden' date variable:

&DATEW

Value today: 4, which is Thursday.

quote:

&DATEW

Mighty Max, dbeagan, Francis thank you for your all your input. Just what I needed.

Question: Is there any documention available that list"Undocumented/hidden" variables? - Just Curious.

The Wizard of Waz has provided a pretty complete list: List of &DATE system variables

Wow! Great job Waz.

By the way, could someone confirm that the oft-mentioned Book Of Dates has these mentioned?

Cheers,