---
schema_version: "1"
id: 6df0621e8a88d2c7fec07b04d6db83e91da0aec3a6b4769c03762bc04611f053
title: day_in_week(date)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions-timezone-day-in-week.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-day-in-week.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 4485b12e6881bc4e2a41ba0069daa011504be11335ab526ab5b1f69859398fda
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# day_in_week(date)

Returns an integer representing the day of the week for a specific date. 1 = Sunday, 2 = Monday and so on.

```nolang
q = foreach q generate day_in_week('OrderDate') as "Day in Week";
```