fiscalQuarterEnd()

returns the last 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 fiscalquarterend(date) parameters parameter type description date docid\ xtaqdzvlbtakjxrnpfwe9 optional the date to calculate the fiscal quarter end 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 last day of the fiscal quarter that contains the given date examples for an organization with a default fiscal year (starts in january) fiscalquarterend('2025 05 12') returns 2025 06 30 because may 12 falls in q2, which ends on june 30 for an organization with a fiscal year starting in february fiscalquarterend('2025 02 15') returns 2025 04 30 because february falls in fiscal q1, which ends on april 30 fiscalquarterend('2025 01 15') returns 2025 01 31 because january falls in fiscal q4, which ends on january 31 using relative date offsets relative date offsets can be passed to resolve dynamically relative to today, without needing to hardcode a specific date fiscalquarterend('+3m') returns the end of the fiscal quarter that is 3 months from today (i e "next quarter" when called during the first month of the current quarter) fiscalquarterend(' 3m') returns the end 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\ iupffy8zadboxenn jmvg returns the start date of the fiscal quarter docid\ usyc tk0v bmtguhk9eib returns the fiscal quarter number (1–4) docid\ jgcef8tww3zsk3fvgdqmt returns the end date of the fiscal year docid\ lvlfv 1a epbysjqj5fjc relative date expressions supported in cql