Office Tips and Hints Blog

Sunday, July 26, 2009 – Permalink –

Fiscal Year in Access

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

[Edited entry from 6/19/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:26 AM

Comments: Post a Comment

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>