fiscalYearStart()
Returns the start date of the fiscal year for a given date, based on your organization's configured fiscal year start month.
If no date is provided, the current context date is used.
Syntax
fiscalYearStart(date)
Parameters
Parameter | Type | Description |
|---|---|---|
date | DateDate | Optional. The date to calculate the fiscal year start from. Defaults to today. |
Return Type
DateDate
The first day of the fiscal year that contains the given date.
Examples
For an organization with a default fiscal year (starts in January):
fiscalYearStart('2025-05-12')
- Returns 2025-01-01 because May 12, 2025 falls within the fiscal year starting January 1, 2025.
For an organization with a fiscal year starting in February:
fiscalYearStart('2025-03-15')
- Returns 2025-02-01 because March 15, 2025 falls within the fiscal year starting February 1, 2025.
fiscalYearStart('2025-01-15')
- Returns 2024-02-01 because January 15, 2025 falls within the fiscal year that started February 1, 2024.
Related Functions
- Relative DatesRelative Dates - Relative date expressions including fiscal year references