Carrot reference
Functions
fiscalYear()
returns the fiscal year number 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 when the fiscal year does not start in january, the fiscal year number is the calendar year in which the fiscal year ends for example, with a february fiscal year start, february 2025 through january 2026 is fiscal year 2026 syntax fiscalyear(date) parameters parameter type description date docid\ xtaqdzvlbtakjxrnpfwe9 optional the date to get the fiscal year for defaults to today return type docid\ uci5tctfvbhonej6zqijg the fiscal year number examples for an organization with a default fiscal year (starts in january) fiscalyear('2025 05 12') returns 2025 for an organization with a fiscal year starting in february fiscalyear('2025 02 12') returns 2026 because february 2025 is the start of fiscal year 2026 (ending january 2026) fiscalyear('2025 01 12') returns 2025 because january 2025 is the last month of fiscal year 2025 related carrot docid\ jplzeg4gb8l9zhw1iitw6 returns the start date of the fiscal year docid\ jgcef8tww3zsk3fvgdqmt returns the end date of the fiscal year docid\ usyc tk0v bmtguhk9eib returns the fiscal quarter number (1–4) docid\ plbqkxfazuh1ntxwgkdb returns the calendar year
