DayOfWeekFromDateTime

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Returns a numerical value, indicating the day of the week corresponding to the specified DateTime value, where 0 = Sunday, 1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday, 5 = Friday and 6 = Saturday.

The integer portion of the DateTime value specifies the number of days since December 30th, 1899, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.

Usage

DayOfWeekFromDateTime(DateTime)

Where:

DateTime - a double-precision decimal DateTime value.

Examples

DayOfWeekFromDateTime(39448.25000000)

Will return a value of 2, indicating Tuesday, for January 1st, 2008.

DayOfWeekFromDateTime(ComputerDateTime)

Returns a value of 0, indicating that today is a Sunday.