DayOfWeek

 

Description

Determines the day of the week, in a date.

Returns

The ordinal for the day of the week, as an integer in the range 1 (Sunday) to 7 (Saturday).

Category

Date and time functions

History

ColdFusion (2018 release) Update 2: Added the parameter calendar.

ColdFusion (2016 release) Update 8: Added the parameter calendar.

Function syntax

DayOfWeek(date)
DayOfWeek(date)
DayOfWeek(date)

Parameters

Parameter

Required/Optional

Description

date

Required

Date/time object, in the range 100 AD-9999 AD.

 

calendar

Optional

Values are either "iso" or "gregorian".

See also

DayDayOfWeekAsStringDayOfYearDaysInMonthDaysInYearFirstDayOfMonth


Usage

When passing a date/time object as a string, enclose it in quotation marks. Otherwise, it is interpreted as a numeric representation of a date/time object.

You can pass the CreateDate function or Now function as the date parameter of this function; for example, #DayOfWeek(CreateDate(2001, 3, 3))#

Example 1

<cfscript>
Date1 = "{ts '2018-11-06 12:13:50'}";
Dayofweek= DayOfWeek(Date1)
// writeOutput(Date1 & "<br/>")
writeOutput("Day of week: " & DayofWeek & "")
</cfscript>
<cfscript> Date1 = "{ts '2018-11-06 12:13:50'}"; Dayofweek= DayOfWeek(Date1) // writeOutput(Date1 & "<br/>") writeOutput("Day of week: " & DayofWeek & "") </cfscript>
<cfscript>
    Date1 = "{ts '2018-11-06 12:13:50'}";
    Dayofweek= DayOfWeek(Date1)
   // writeOutput(Date1 & "<br/>")
    writeOutput("Day of week: " & DayofWeek & "")
</cfscript>

Output

Day of week: 3

Example 2

<cfscript>
dateTime = createDate(2016,1,3); //Sunday, January 3, 2016
writeOutput(dayOfWeek(dateTime, "iso"));
</cfscript>
<cfscript> dateTime = createDate(2016,1,3); //Sunday, January 3, 2016 writeOutput(dayOfWeek(dateTime, "iso")); </cfscript>
<cfscript>
    dateTime = createDate(2016,1,3); //Sunday, January 3, 2016
    writeOutput(dayOfWeek(dateTime, "iso"));
</cfscript>

Output

7

Get help faster and easier

New user?