<div>
I prefer the following syntax:<br />
<br />
&gt;= Date() AND &lt;&nbsp;DateSerial(Year(date()) + 1, 1, 1)
</div>


I prefer the following syntax:

>= Date() AND < DateSerial(Year(date()) + 1, 1, 1)

<div>
Not knowing whether the field you are trying to filter on contains only date data, if you use the BETWEEN syntax, and use DateSerial(Year(Date()) + 1, 1, 1) then you would also retrieve data for Jan 1, 2015. &nbsp;By using the &lt;&nbsp;you are certain to get only data pertaining to 2014.
</div>


Not knowing whether the field you are trying to filter on contains only date data, if you use the BETWEEN syntax, and use DateSerial(Year(Date()) + 1, 1, 1) then you would also retrieve data for Jan 1, 2015.  By using the < you are certain to get only data pertaining to 2014.

<div>
Dale, thanks. &nbsp;I think I need to include days that are 5 days after year end. &nbsp;I think I would need Between and that DateSerial if I am thinking correctly. &nbsp;Not sure exactly what I need to change for 5 days after year end. &nbsp;Could you help me with that?
</div>


Dale, thanks.  I think I need to include days that are 5 days after year end.  I think I would need Between and that DateSerial if I am thinking correctly.  Not sure exactly what I need to change for 5 days after year end.  Could you help me with that?

<div>
<div class="content wysiwyg-content">
Experts, <br />
<br />
I need a formula that returns data between the current date and the year end. <br />
<br />
I have the following and I need to modify it as so. <br />
<i>Between Date() And Date()+Nz([Enter Number of Days in Future],100000) Or Is Null</i><br />
<br />
thank you
</div>
</div>


Experts, 

I need a formula that returns data between the current date and the year end. 

I have the following and I need to modify it as so. 
Between Date() And Date()+Nz([Enter Number of Days in Future],100000) Or Is Null

thank you

Between Date and Year End

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.