fiscalQuarter()

returns the fiscal quarter number (1–4) 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 fiscalquarter(date) parameters parameter type description date date docid\ xtaqdzvlbtakjxrnpfwe9 optional the date to get the fiscal quarter for defaults to today return type number docid\ uci5tctfvbhonej6zqijg a number from 1 to 4 representing the fiscal quarter examples for an organization with a default fiscal year (starts in january) fiscalquarter('2025 05 12') returns 2 because may falls in q2 (april–june) for an organization with a fiscal year starting in february fiscalquarter('2025 02 15') returns 1 because february is the first month of the fiscal year, placing it in q1 fiscalquarter('2025 01 15') returns 4 because january falls in the last quarter of a feb–jan fiscal year related carrot fiscalquarterstart() docid\ iupffy8zadboxenn jmvg returns the start date of the fiscal quarter fiscalquarterend() docid\ qjfkaw x26wzrpkrkt2if returns the end date of the fiscal quarter fiscalyear() docid 4mbfwcnmkoykgktotswdb returns the fiscal year number fiscalyearstart() docid\ jplzeg4gb8l9zhw1iitw6 returns the start date of the fiscal year