---
schema_version: "1"
id: fd2154d5c27fad49fd8ab80123c325c3966adf920741c500fb0bd24d9700741d
title: fiscal_year_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-year-first-day.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-fiscal-year-first-day.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 592a6ed4442339677868a2b7bef6aedc79b77ffd4b647f1823b46c380b9f648a
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# fiscal_year_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 year that contains the specified date. By default, the fiscal year begins on February 1.

## Example

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

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