Skip to main content Link Search Menu Expand Document (external link)

dayOfWeek() : Extract Day of Week from Date

On this page

Summary

Extract the day of the week from a datetime value as a number (0-6), where 0 is Sunday and 6 is Saturday.

Signature 

dayOfWeek(date)

Parameters

Parameter Type Required Description
date DateTime Yes The datetime to extract the day of week from

Returns

Type: Number (Integer)

The day of the week as a number from 0 (Sunday) to 6 (Saturday).

Examples

Display Day Number 

<p>Day of week: </p>

Data:

doc.Params["model"] = new {
    date = new DateTime(2024, 3, 15)  // Friday
};

Output:

<p>Day of week: 5</p>

Weekend Detection 

<p>:

  Weekend

  Weekday

</p>

Data:

doc.Params["model"] = new {
    date = new DateTime(2024, 3, 16)  // Saturday
};

Output:

<p>Saturday, March 16: Weekend</p>

Business Days Filter 

<h3>Business Day Appointments</h3>

  
    <p>: </p>

Data:

doc.Params["model"] = new {
    appointments = new[] {
        new { date = new DateTime(2024, 3, 15), description = "Team Meeting" },      // Friday
        new { date = new DateTime(2024, 3, 16), description = "Workshop" },          // Saturday
        new { date = new DateTime(2024, 3, 18), description = "Client Call" }       // Monday
    }
};

Output:

<h3>Business Day Appointments</h3>
<p>Fri Mar 15: Team Meeting</p>
<p>Mon Mar 18: Client Call</p>

Shift Schedule 


  <p>:
  
    Morning Shift
  
    Afternoon Shift
  
    Night Shift
  
    Off
  
  </p>

Data:

doc.Params["model"] = new {
    dates = new[] {
        new DateTime(2024, 3, 18),  // Monday
        new DateTime(2024, 3, 20),  // Wednesday
        new DateTime(2024, 3, 22),  // Friday
        new DateTime(2024, 3, 23)   // Saturday
    }
};

Output:

<p>Mar 18: Morning Shift</p>
<p>Mar 20: Afternoon Shift</p>
<p>Mar 22: Night Shift</p>
<p>Mar 23: Off</p>

Notes

  • Returns 0-6 where 0 = Sunday, 1 = Monday, …, 6 = Saturday
  • Based on .NET DayOfWeek enumeration
  • Time component is ignored
  • For day names, use format(date, 'dddd') for full name or format(date, 'ddd') for abbreviated
  • Useful for weekend/weekday logic and scheduling patterns
  • Common patterns:
    • Weekend: dayOfWeek == 0 || dayOfWeek == 6
    • Weekday: dayOfWeek >= 1 && dayOfWeek <= 5

See Also