ACCESS FEED: RE: [MS_AccessPros] Finding "Next Fiscal Year"

Selasa, 14 Mei 2013

RE: [MS_AccessPros] Finding "Next Fiscal Year"

Thanks John,

Tested and working.

Robin Chapple

At 14/05/2013 10:38 PM, you wrote:
>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
>
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>