Fiscal Year in Access

Make up your own year

You can show a custom Fiscal Year starting June, 1 and ending May 31.

BeginFiscalYr = DateSerial(Year(Date), 6, 1)

EndFiscalYr = DateSerial(Year(Date) + 1, 6, 1) - 1

Also:
Calculating a future or past date in Access



See all Topics