<div>
if FutureDate - getdate () &lt;= 21 ...
</div>


<div>
I don't understand<br />
<br />
I want all the records starting at the form field date and 21 days before that
</div>


I don't understand

I want all the records starting at the form field date and 21 days before that

<div>
Assuming this is Access, then you will need something like this in the WHERE clause of your query:<br />
<br />

<pre><code id="code-20-37027912-1">WHERE DateInTheTable &lt;= (CDate(Forms![NameOfForm]![NameOfDateField]) - 21)</code></pre>
</div>


Assuming this is Access, then you will need something like this in the WHERE clause of your query:



WHERE DateInTheTable <= (CDate(Forms![NameOfForm]![NameOfDateField]) - 21)

<div>
tried that with this SQL not working<br />
<br />
SELECT tblddai_renewalpostdate.da<wbr />terenewalp<wbr />osted<br />
FROM tblddai_renewalpostdate<br />
WHERE (((tblddai_renewalpostdate<wbr />.daterenew<wbr />alposted)=<wbr />([Forms]![<wbr />frmDDAI_SB<wbr />]![txtStar<wbr />tDate])-21<wbr />));<br />

</div>


tried that with this SQL not working

SELECT tblddai_renewalpostdate.daterenewalposted
FROM tblddai_renewalpostdate
WHERE (((tblddai_renewalpostdate.daterenewalposted)=([Forms]![frmDDAI_SB]![txtStartDate])-21));


<div>
You are most welcome! Note my comment was in support of Patrick's regarding CDate(). If that is what solved the issue, then please know you won't offend me any by requesting a Moderator change this to a split or credit to Patrick. If the DateAdd() is what did it, then glad that helped!<br />
<br />
Best regards and happy coding,<br />
<br />
Kevin
</div>


You are most welcome! Note my comment was in support of Patrick's regarding CDate(). If that is what solved the issue, then please know you won't offend me any by requesting a Moderator change this to a split or credit to Patrick. If the DateAdd() is what did it, then glad that helped!

Best regards and happy coding,

Kevin

<div>
<div class="content wysiwyg-content">
I have a fiedl on a form, I wan to return all the records 21 days before that day<br />
<br />
I gave tried &lt;=Date() -21<br />
<br />
and load others but can't get it working<br />
<br />
Any ideas
</div>
</div>


I have a fiedl on a form, I wan to return all the records 21 days before that day

I gave tried <=Date() -21

and load others but can't get it working

Any ideas

Qury between 2 dates

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.