WEEKDAYOF

Syntax

WEEKDAYOF(date_string [, input_format])

Parameters

date_string

A text representing a valid date.

input_format

One of the keywords in the table below, specifying the date format of date_string.

Description

WEEKDAYOF returns the day of the week as a number between 0-6 (Sunday 0, Monday 1, and so on) for the date specified by the date_string. If input_format is not provided, the default keyword DELIM_M_D_Y will be used.

Examples

WEEKDAYOF("08312000", MMDDYYYY) returns the number 4, since Thursday is the 4th day of the week.

See DATE for additional information on valid date formats.

Related Functions

Function	Description
DAYOF	Returns the day of the month as a number.
MONTHOF	Returns the month of the year as a number.
YEAROF	Returns the year as a number.