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