<div>
Use something like <br />
WHERE DATE BETWEEN DATEADD(&quot;yyyy&quot;,-6, Date Passed) and DatePassed
</div>


Use something like
WHERE DATE BETWEEN DATEADD("yyyy",-6, Date Passed) and DatePassed

<div>
I am getting a &quot;The expression you entered has an invalid string&quot; A string can be up to 2048 char long, including opening and closing quotation marks
</div>


I am getting a "The expression you entered has an invalid string" A string can be up to 2048 char long, including opening and closing quotation marks

<div>
found it<br />
<br />
(&quot;yyyy'
</div>


<div>
is my thinking correct on this?<br />
<br />
If I am going back 6 yrs from a date ( 06/15/2015 ) would that be in between 6/01/2009 to 5/31/2010?<br />
<br />
or is it between 5/31/2008 to 6/01/2009?
</div>


is my thinking correct on this?

If I am going back 6 yrs from a date ( 06/15/2015 ) would that be in between 6/01/2009 to 5/31/2010?

or is it between 5/31/2008 to 6/01/2009?

<div>
Not sure &nbsp;- open the immediate window of VBA and type in the expression as ?Datevalue(with your details) and see what it returns.<br />
<br />
<br />
Kelvin
</div>


Not sure  - open the immediate window of VBA and type in the expression as ?Datevalue(with your details) and see what it returns.


Kelvin

<div>
<div class="content wysiwyg-content">
I need help with a query on one of my tables. On one of the table fields there is a date mm/dd/yyyy. I need to have the user input a future date and then count back 6 years from the table field date. I only want to see the dates that fall in the 6 year window.<br />
<br />
&nbsp;ex: user input - 06/01/2015<br />
<br />
&nbsp;the query would pull only the dates starting 06/01/2009 to 05/31/2010
</div>
</div>


I need help with a query on one of my tables. On one of the table fields there is a date mm/dd/yyyy. I need to have the user input a future date and then count back 6 years from the table field date. I only want to see the dates that fall in the 6 year window.

 ex: user input - 06/01/2015

 the query would pull only the dates starting 06/01/2009 to 05/31/2010

Access 2007 Date Query Criteria -6 by 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.