<<

Contents

Search

>>

 

DAYOFWEEK

 

 

Function

 

 

Syntax:

DAYOFWEEK(<Date>)

 

<Date> = <NUM-EXPRESSION>

 

Meaning:

Returns the day of week of  <Date>.

 

<Date> must be a valid date in the form YYJMMDD or YYYYMMDD.

If  <Date> is an invalid date or 0, DAYOFWEEK returns the value ‑1.

 

DAYOFWEEK returns one of these values:

1 = Monday

2 = Tuesday

3 = Wednesday

4 = Thursday

5 = Friday

6 = Saturday

7 = Sunday

-1 = invalid Date

 

Parameter:

Date

Numeric date

 

Sample:

CASE DAYOFWEEK(NUMDATE(DATEG$))

  OF 1 DAY$ = "Monday"

  OF 2 DAY$ = "Tuesday"

  OF 3 DAY$ = "Wednesday"

  OF 4 DAY$ = "Thursday"

  OF 5 DAY$ = "Friday"

  OF 6 DAY$ = "Saturday"

  OF 7 DAY$ = "Sunday"

ENDCASE

 

See also:

WEEKOFYEAR

DATEADD

DATEDIFF

NUMDATE

STRDATE$

DATE$

DATEG$

DATEG8$