*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Fields to Include in Queries that use Fiscal Year
| Table | Field | Notes |
|---|---|---|
Restricting Your Query Results by Fiscal Year
...
then add this parameter filter at the top of your query. Note that the dates below correspond to the start and end of Fiscal Year 2023.
/* Enter the start date and end date in YYYY-MM-DD format */ '2022-07-01'AS start_date, '2023-06-30'AS end_date,
Alternatively, you can use a fiscal year field in your query and include a parameter at the top of the query that allows the person running it to restrict results by a given fiscal year.
...