Wednesday, April 20, 2016

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

No comments: