<div>
you aare right, i did just that and the 4 dates in the table are off &nbsp; . i.e. 1978 for some reason &nbsp;so you are both right. Thanks you very much
</div>


you aare right, i did just that and the 4 dates in the table are off   . i.e. 1978 for some reason  so you are both right. Thanks you very much

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for rschmehl's comment <a href="https://www.experts-exchange.com/questions/28480455/sql-datediff-returning-wrong-number.html?anchorAnswerId=40209793#a40209793" rel="ugc">#a40209793</a><br />
Assisted answer: 250 points for Jim Horn's comment <a href="https://www.experts-exchange.com/questions/28480455/sql-datediff-returning-wrong-number.html?anchorAnswerId=40209578#a40209578" rel="ugc">#a40209578</a><br />
Assisted answer: 250 points for Brian Crowe's comment <a href="https://www.experts-exchange.com/questions/28480455/sql-datediff-returning-wrong-number.html?anchorAnswerId=40209595#a40209595" rel="ugc">#a40209595</a><br />
<br />
for the following reason:<br />
<br />
Jim and Brian are both rigtt
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for rschmehl's comment #a40209793 [https://www.experts-exchange.com/questions/28480455/sql-datediff-returning-wrong-number.html?anchorAnswerId=40209793#a40209793]
Assisted answer: 250 points for Jim Horn's comment #a40209578 [https://www.experts-exchange.com/questions/28480455/sql-datediff-returning-wrong-number.html?anchorAnswerId=40209578#a40209578]
Assisted answer: 250 points for Brian Crowe's comment #a40209595 [https://www.experts-exchange.com/questions/28480455/sql-datediff-returning-wrong-number.html?anchorAnswerId=40209595#a40209595]

for the following reason:

Jim and Brian are both rigtt

<div>
<div class="content wysiwyg-content">
In the attachment you can see the code and the results the Months columin is wrong, not sure why. <a href="https://filedb.experts-exchange.com/incoming/2014/07_w30/861888/Capture.PNG" target="_blank" title="Capture.PNG (41 KB)"><img alt="Capture.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/07_w30/800_861888/Capture.PNG" /></a>
</div>
</div>


Capture.PNG

In the attachment you can see the code and the results the Months columin is wrong, not sure why. 

sql datediff returning wrong number

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.