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)

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>

Output

Day of week: 3

Example 2

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

Output

7

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy