<div>
<div class="content wysiwyg-content">
I currently have a query in Excel that the date is being changed manually each month. I would like the code so that the date will be based on the today's date so the code will not have to be changed.<br />
<br />
I would like to check DATEA is within the last 12 months<br />
<br />
I would like to check DATEB &gt;= &nbsp;today and DATEB is &lt;&nbsp;today +1 &nbsp; (essentially = to today, but because the query uses both parameters I would like to leave the option for a range.
</div>
</div>


I currently have a query in Excel that the date is being changed manually each month. I would like the code so that the date will be based on the today's date so the code will not have to be changed.

I would like to check DATEA is within the last 12 months

I would like to check DATEB >=  today and DATEB is < today +1   (essentially = to today, but because the query uses both parameters I would like to leave the option for a range.

Checking for date in msquery in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.