---
schema_version: "1"
id: 442cc6c1263c8200aad4ad73b6025925cfa1fc3414eae8140cd5f95d80a6766a
title: fiscal_quarter_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-quarter-first-day.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-fiscal-quarter-first-day.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 95ad9781033c8b27efabf79be3d184b6694289cfec9394d0f1bd2e88e25c1e9f
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# fiscal_quarter_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 of the fiscal quarter that contains the specified date. By default, the first fiscal quarter is defined as February, March, April. The second quarter is May, June, July. The third is August, September, October. The fourth is November, December, January.

## Example

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

| date                | fiscal_quarter_first_day |
| ------------------- | ------------------------ |
| 2015-01-21 15:30:00 | 2014-11-01 00:00:00      |
| 2015-01-21 00:00:00 | 2014-11-01 00:00:00      |
| 2015-01-31 10:00:30 | 2014-11-01 00:00:00      |
| 2015-02-03 15:30:00 | 2015-02-01 00:00:00      |
| 2016-01-21 23:59:59 | 2015-11-01 00:00:00      |
| 2015-10-31 23:59:59 | 2015-08-01 00:00:00      |
| 2015-12-03 00:00:00 | 2015-11-01 00:00:00      |
| 2016-01-11 03:30:00 | 2015-11-01 00:00:00      |
| 2016-01-11 03:30:00 | 2015-11-01 00:00:00      |