<div>
Try this...<br />
<br />
FYear: Format(DateAdd(&quot;m&quot;, -6, #6/30/2009#), &quot;q&quot;&quot;Q&quot;&quot;yyyy&quot;)
</div>


Try this...

FYear: Format(DateAdd("m", -6, #6/30/2009#), "q""Q""yyyy")

<div>
/thank you for the prompt response; unfortunately, the formula provided incorrectly returns the year 2008 to all dates (i.e 8/30/2007 = 1Q2007 and the formula returns 4Q2008)), and I do not believe it is calculating the quarter. Since the fiscal year starts 7/1, I believe the quarter should calculate as follows:<br />
July Aug Sept = 1Q<br />
Oct Nov Dec = 2Q<br />
Jan Feb Mar = 3Q<br />
Apr May Jun = 4Q<br />
<br />
Again, any assistance is greatly appreciated! Thank you in advance... <br />
<br />

</div>


/thank you for the prompt response; unfortunately, the formula provided incorrectly returns the year 2008 to all dates (i.e 8/30/2007 = 1Q2007 and the formula returns 4Q2008)), and I do not believe it is calculating the quarter. Since the fiscal year starts 7/1, I believe the quarter should calculate as follows:
July Aug Sept = 1Q
Oct Nov Dec = 2Q
Jan Feb Mar = 3Q
Apr May Jun = 4Q

Again, any assistance is greatly appreciated! Thank you in advance...



<div>
Perfect! Thank you so very much for your prompt and expert response. 
</div>


Perfect! Thank you so very much for your prompt and expert response.

<div>
<div class="content wysiwyg-content">
I use the following expression in an MS Access Query to return the fiscal year for a given date: FYear: Year([Date])-IIf([Date]&lt;Da<wbr />teSerial(Y<wbr />ear([Date]<wbr />),7,1),1,0<wbr />). (Fiscal Year starts 7/1 and ends 6/30).<br />
I am requesting assistance in writing an expression that will return the fiscal quarter for a given date. (i.e. 3/1/09 = 3Q2008).<br />
Thank you in advance! 
</div>
</div>


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! 

Determine fiscal quarter based on date

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.