<div>
Perfect - thanks very much Dale :)
</div>


<div>
<blockquote>
this date needs to be 30 days after the Invoice Date then paid by the end of that month 
</blockquote>
So if your invoice date is January 1, 30 days later is January 31. &nbsp;So the end of that month is still January 31.<br />
I'm sure your intention is to have the due date at the end of February instead in which case Dale's answer is exactly what you need.<br />
<br />
Ron
</div>


> this date needs to be 30 days after the Invoice Date then paid by the end of that month

So if your invoice date is January 1, 30 days later is January 31.  So the end of that month is still January 31.
I'm sure your intention is to have the due date at the end of February instead in which case Dale's answer is exactly what you need.

Ron

<div>
Good point - yes my intention is to have the due date at the end of February and Dales answer works perfectly :)
</div>


Good point - yes my intention is to have the due date at the end of February and Dales answer works perfectly :)

<div>
<div class="content wysiwyg-content">
I want to create a query that identifies an Invoice Due Date:<br />
<br />
Invoice Date - eg 02/02/2017<br />
Invoice Due Date - this date needs to be 30 days after the Invoice Date then paid by the end of that month eg 31/03/2017<br />
<br />
Any ideas?
</div>
</div>


I want to create a query that identifies an Invoice Due Date:

Invoice Date - eg 02/02/2017
Invoice Due Date - this date needs to be 30 days after the Invoice Date then paid by the end of that month eg 31/03/2017

Any ideas?

Date Diff Query in Access 2010

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.