I use the following expression in an MS Access Query to return the fiscal year for a given date: FYear: Year([Date])-IIf([Date]<DateSerial(Year([Date]),7,1),1,0). (Fiscal Year starts 7/1 and ends 6/30).
I am requesting assistance in writing an expression that will return the fiscal quarter for a given date. (i.e. 3/1/09 = 3Q2008).
Thank you in advance!