[AccessD] Calculate first day of financial year

Anita Smith anitatiedemann at gmail.com
Sun Apr 19 03:20:08 CDT 2009


Thanks a ton Steve - that's pretty elegant - it goes straight to my toolbox.

Anita

On Sun, Apr 19, 2009 at 6:10 PM, Steve Schapel <miscellany at mvps.org> wrote:

> 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?
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list