Robin-
Without testing it, I would guess:
>"30/06/" & Year(DateAdd("m",+6,Date()))
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Monday, May 13, 2013 7:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Finding "Next Fiscal Year"
Our organisation has a fiscal year from 1st July to 30th June.
This group advised the code to find "This Fiscal Year":
>"30/06/" & Year(DateAdd("m",-6,Date()))
How do I change that to find the next fiscal year?
Many thanks,
Robin Chapple
------------------------------------
Yahoo! Groups Links
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar