Fiscal Year and Quarter "JohnC" <anonymous[ at ]news.groups.com> 13.09.2006 03:18:30 This fantastic expression was posted by Duane Hookom. I have no idea how it works but it displays the fiscal year and quarter for FY starting on October 1. =Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0) It displays the first quarter for FY 2007 as Q1 2007. However I would like to display this as 2007 Q1. I couldn't get this to work. JohnC

Re: Fiscal Year and Quarter "tina" <nospam[ at ]address.com> 13.09.2006 03:47:55 try =Format$(DateAdd("q",1,Date()),"yyyy"" Q""q",0,0) or =Format$(DateAdd("q",1,Date()),"yyyy \Qq",0,0) hth "JohnC" <anonymous[ at ]news.groups.com> wrote in message news:e28b9$45077864$40971c7d$15821[ at ]EVERESTKC.NET... [Quoted Text] > This fantastic expression was posted by Duane Hookom. I have no idea how it > works but it displays the fiscal year and quarter for FY starting on October > 1. > > =Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0) > > It displays the first quarter for FY 2007 as Q1 2007. > > However I would like to display this as 2007 Q1. I couldn't get this to > work. > > JohnC > >

Re: Fiscal Year and Quarter "J. Goddard" <jrgoddard[ at ]NO_cyberus_SPAM.ca> 13.09.2006 03:49:24 Try =Format$(DateAdd("q",1,[Onset Date]),"yyyy \Qq",0,0) John JohnC wrote: [Quoted Text] > This fantastic expression was posted by Duane Hookom. I have no idea how it > works but it displays the fiscal year and quarter for FY starting on October > 1. > > =Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0) > > It displays the first quarter for FY 2007 as Q1 2007. > > However I would like to display this as 2007 Q1. I couldn't get this to > work. > > JohnC > >