---
schema_version: "1"
id: 3ca91153a08477ba0870ca9b49a25efa30eb6ad9b6723a38521fc2808dbdaf69
title: fiscal_week_first_day({date})
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-date-fiscal-week-first-day.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-fiscal-week-first-day.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: e9e9490aa597b0b8c7fb6a1f7a55ea9c16069e852a0f3994629becf08df330ad
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# fiscal_week_first_day({date})

Accepts a `DateTime`, `DateOnly`, or legacy Date object as input. Returns an object of the same type that corresponds to the first day (Monday) of the fiscal week that contains the specified date.

## Example

```nolang
SELECT OrderDate as "date", fiscal_week_first_day(OrderDate) as "fiscal_week_first_day" FROM "dates_sample_data";
```

| date                | fiscal_week_first_day |
| ------------------- | --------------------- |
| 2015-01-21 15:30:00 | 2015-01-19 00:00:00   |
| 2015-01-21 00:00:00 | 2015-01-19 00:00:00   |
| 2015-01-31 10:00:30 | 2015-01-26 00:00:00   |
| 2015-02-03 15:30:00 | 2015-02-02 00:00:00   |
| 2016-01-21 23:59:59 | 2016-01-18 00:00:00   |
| 2015-10-31 23:59:59 | 2015-10-26 00:00:00   |
| 2015-12-03 00:00:00 | 2015-11-30 00:00:00   |
| 2016-01-11 03:30:00 | 2016-01-11 00:00:00   |
| 2016-01-11 03:30:00 | 2016-01-11 00:00:00   |