[MS_AccessPros] Finding a financial year.

 

I have had a great deal of help arriving at an expression that
decides if today is within the financial year 1st July to 30th June.

Now I have a database where a date is recorded when a donation is
made and I need to extract from the entered date which financial
start date it is in.

For instance a recorded date of 23rd February 2009 needs to show as
year commencing 1st July 2008. This will be an extra field in a
query, because it will happen on a remote server, so I need the SQL
that will populate that field for me.

I hope that I have explained sufficiently.

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 6
• New Files 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

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

.

__,_._,___