<div>
just put format(xxx, &quot;yyyy&quot;) around the original code (insert code in place of xxx)<br />

</div>


just put format(xxx, "yyyy") around the original code (insert code in place of xxx)


<div>
Thank you, cap. What can I say, you are genius.<br />
I wish you a very happy holiday season!
</div>


Thank you, cap. What can I say, you are genius.
I wish you a very happy holiday season!

<div>
Thank you, kmslogic and capricorn1. However cap's is working with no trouble. Wishing you all the best!!!<br />

</div>


Thank you, kmslogic and capricorn1. However cap's is working with no trouble. Wishing you all the best!!!


<div>
<div class="content wysiwyg-content">
Hi experts, <br />
<br />
I copied DatabaseMX's code as following from EE, used it in my database, it's so beautiful.<br />
=DatePart(&quot;q&quot;,DateAdd(&quot;m&quot;,<wbr />-3,[startt<wbr />ime])) &amp;&nbsp;&quot;-&quot; &amp;&nbsp;Year([starttime])-IIf(Mont<wbr />h([startti<wbr />me])&gt;=3,0,<wbr />1) &amp;&nbsp;&quot;/&quot; &amp;&nbsp;Year([starttime])-IIf(Mont<wbr />h([startti<wbr />me])&gt;=3,0,<wbr />1)+1<br />
Now I'd like to have the year part only like 2009/2010, I'm assuming I took out the first part it would work, the code like the following: <br />
=DatePart(Year([starttime]<wbr />)-IIf(Mont<wbr />h([startti<wbr />me])&gt;=3,0,<wbr />1) &amp;&nbsp;&quot;/&quot; &amp;&nbsp;Year([starttime])-IIf(Mont<wbr />h([startti<wbr />me])&gt;=3,0,<wbr />1)+1<br />
But it says &quot;The expression you entered is missing a closing parenthesis, bracket (]), or vertical bar (1).<br />
Please advise.<br />
<br />
Thank you!<br />
<br />
<br />

</div>
</div>


Hi experts, 

I copied DatabaseMX's code as following from EE, used it in my database, it's so beautiful.
=DatePart("q",DateAdd("m",-3,[starttime])) & "-" & Year([starttime])-IIf(Month([starttime])>=3,0,1) & "/" & Year([starttime])-IIf(Month([starttime])>=3,0,1)+1
Now I'd like to have the year part only like 2009/2010, I'm assuming I took out the first part it would work, the code like the following: 
=DatePart(Year([starttime])-IIf(Month([starttime])>=3,0,1) & "/" & Year([starttime])-IIf(Month([starttime])>=3,0,1)+1
But it says "The expression you entered is missing a closing parenthesis, bracket (]), or vertical bar (1).
Please advise.

Thank you!




Fiscal Year Calculation

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.