fiscalYearEnd()

returns the last date of the fiscal year 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 fiscalyearend(date) parameters parameter type description date docid\ xtaqdzvlbtakjxrnpfwe9 optional the date to calculate the fiscal year end from defaults to today return type docid\ xtaqdzvlbtakjxrnpfwe9 the last day of the fiscal year that contains the given date examples for an organization with a default fiscal year (starts in january) fiscalyearend('2025 05 12') returns 2025 12 31 because may 12, 2025 falls within the fiscal year ending december 31, 2025 for an organization with a fiscal year starting in february fiscalyearend('2025 03 15') returns 2026 01 31 because march 2025 falls within the fiscal year ending january 31, 2026 fiscalyearend('2025 01 15') returns 2025 01 31 because january 2025 falls within the fiscal year ending january 31, 2025 related carrot docid\ jplzeg4gb8l9zhw1iitw6 returns the start date of the fiscal year docid 4mbfwcnmkoykgktotswdb returns the fiscal year number docid\ qjfkaw x26wzrpkrkt2if returns the end date of the fiscal quarter