Carrot reference
Functions
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 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 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
