fiscalQuarterStart()

returns the start date of the fiscal quarter 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 fiscalquarterstart(date) parameters parameter type description date docid\ xtaqdzvlbtakjxrnpfwe9 optional the date to calculate the fiscal quarter start from defaults to today accepts hardcoded dates (e g '2025 05 01' ) or docid\ lvlfv 1a epbysjqj5fjc (e g '+3m' , ' 3m' ) return type docid\ xtaqdzvlbtakjxrnpfwe9 the first day of the fiscal quarter that contains the given date examples for an organization with a default fiscal year (starts in january) fiscalquarterstart('2025 05 12') returns 2025 04 01 because may 12 falls in q2, which starts on april 1 for an organization with a fiscal year starting in february fiscalquarterstart('2025 03 15') returns 2025 02 01 because march falls in fiscal q1, which starts on february 1 fiscalquarterstart('2025 01 15') returns 2024 11 01 because january falls in fiscal q4, which started on november 1 of the previous calendar year using relative date offsets relative date offsets can be passed to resolve dynamically relative to today, without needing to hardcode a specific date fiscalquarterstart('+3m') returns the start of the fiscal quarter that is 3 months from today (i e "next quarter" when called during the first month of the current quarter) fiscalquarterstart(' 3m') returns the start of the fiscal quarter that is 3 months ago (i e "last quarter") this is especially useful for dynamic date filters in reports and dashboards for example closedate >= fiscalquarterstart('+3m') and closedate <= fiscalquarterend('+3m') this expression will always refer to next quarter's date range without needing manual updates related carrot docid\ qjfkaw x26wzrpkrkt2if returns the end date of the fiscal quarter docid\ usyc tk0v bmtguhk9eib returns the fiscal quarter number (1–4) docid\ jplzeg4gb8l9zhw1iitw6 returns the start date of the fiscal year docid\ lvlfv 1a epbysjqj5fjc relative date expressions supported in cql