[AccessD] Calculate first day of financial year

Anita,

Don't know if anyone will come up with one more elegant than:
DateSerial(Year(Date())+(Month(Date())<7),7,1)

Regards
Steve


--------------------------------------------------
From: "Anita Smith" <anitatiedemann at gmail.com>
Sent: Sunday, April 19, 2009 7:39 PM
To: <AccessD at databaseadvisors.com>
Subject: [AccessD] Calculate first day of financial year

> Hi All,
> The financial year starts on the 1st of July in Australia.
>
> Does anyone out there have a nifty formula that I can use to calculate the
> first day of the current financial year based on todays date?
>