<div>
DateDiff(&quot;m&quot;, NZ([DriversTermed], CDate(&quot;1/&quot; &amp;&nbsp;Month(Date) &amp;&nbsp;&quot;/&quot; &amp;&nbsp;Year(Date))),<br />
IIF(Day([DriversEffective]<wbr />) &gt;&nbsp;1, DateAdd(&quot;m&quot;, 1, [DriversEffective]), [DriversEffective]))<br />
<br />
Steve
</div>


DateDiff("m", NZ([DriversTermed], CDate("1/" & Month(Date) & "/" & Year(Date))),
IIF(Day([DriversEffective]) > 1, DateAdd("m", 1, [DriversEffective]), [DriversEffective]))

Steve

<div>
SELECT &nbsp;DateAdd(&quot;m&quot;,IIf(Day(dat1)&lt;<wbr />16,0,1),Da<wbr />teSerial(Y<wbr />ear(dat1),<wbr />Month(dat1<wbr />),1)) as d1, nz(dat2,dateadd(&quot;m&quot;,1,d1))<wbr /> as d2, datediff(&quot;m&quot;,d1,d2)
</div>


SELECT  DateAdd("m",IIf(Day(dat1)<16,0,1),DateSerial(Year(dat1),Month(dat1),1)) as d1, nz(dat2,dateadd("m",1,d1)) as d2, datediff("m",d1,d2)

<div>
<div class="content wysiwyg-content">
MS Access 2003 QUERY<br />
Help! &nbsp;I need to calculate the number of months due based on the following criteria:<br />
<br />
[Efective] = If [DriversEffective] datepart is prior to the 16th of any given month the count that month as the first month, otherwise begin month count the following month.<br />
<br />
[EndDate] = If [DriversTermed] is null then [EndDate] = 1st of next month, otherwise, [EndDate] = [DriversTermed]<br />
<br />
[EndDate] minus [Effective] &nbsp;(in number of months)<br />
<br />
I need this in SQL so I can put it into a query. &nbsp;Any help is appreciated<br />
<br />
<br />

</div>
</div>


MS Access 2003 QUERY
Help!  I need to calculate the number of months due based on the following criteria:

[Efective] = If [DriversEffective] datepart is prior to the 16th of any given month the count that month as the first month, otherwise begin month count the following month.

[EndDate] = If [DriversTermed] is null then [EndDate] = 1st of next month, otherwise, [EndDate] = [DriversTermed]

[EndDate] minus [Effective]  (in number of months)

I need this in SQL so I can put it into a query.  Any help is appreciated




Counting months between two dates

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.

Microsoft Access

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.