Fiscal Year

Determine which fiscal year a date falls in.

Fiscal Year
Copy  •  js
if(empty(prop("Date")), "", if(month(prop("Date")) + 1 <= 4 and date(prop("Date")) < 6, format(year(prop("Date")) - 1) + " – " + format(year(prop("Date"))), format(year(prop("Date"))) + " – " + format(year(prop("Date")) + 1)))
Previous & Next