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 true 220,220,221 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type 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