Are you currently in FY2012 or FY2013?
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> 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
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar