[MS_AccessPros] Finding "This Fiscal Year"

 

We have a fiscal year which runs from 1st July to 30th June. I need
to find dates that are within "This Fiscal Year".

I had a similar need and the group advised this SQL which works for
the first requirement.

>IIf(Month(Date())>=7,DateSerial(Year(Date()),7,1),DateSerial(Year(Date())-1,7,1))

It is currently finding dates after 1/7/2012.

What do I need to do to change it?

Many thanks,

Robin Chapple

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___