WEEKDAY_NR

Use the WEEKDAY_NR script function to return the day of the week of a particular date. The weekday is returned as a single-digit number.

Syntax

WEEKDAY_NR ([DateFormat:]Date)

Parameters

• WEEKDAY_NR
  Determines the day of the week for a specified date

• Date
  Specifies the date
  Format: script literal or script variable
  Note: Specify the date format when you use a format other than YYMMDD or YYYYMMDD. Separate the date format and the date with a colon or semicolon. For more information, see Date, Time and Period Formats in Scripts.

Return Codes

The script function returns the following values:

• 1
  Monday
• 2
  Tuesday
• 3
  Wednesday
• 4
  Thursday
• 5
  Friday
• 6
  Saturday
• 7
  Sunday
  

Examples

December 31, 1999 was a Friday, so the following script returns the value 5:

:SET &NEWYEARSEVE_2000# = WEEKDAY_NR('DD.MM.YY:31.12.99')

January 1, 2000 was a Saturday, so the following script returns the value 6:

:SET &NEWYEAR_2000# = WEEKDAY_NR("DD.MM.YYYY:01.01.2000")

In both examples, the date format is specified because the dates provided are not in YYMMDD or YYYYMMDD format.

See also: