dear sir m working with banking domain. kindly check out two dates i hav to display the loan-defaulter list from my loan date and and the last date on which i have paid my last installment i have to find out the month from last three queries i req the bold one. but it is the wrong answer date diff is only 18 days but it showing 1 month so dat my calculation goes wrong.
select datediff(month , '2010/12/14' , '2011/01/01') gives 1 month as date difference *select datediff(day, '2010/12/14' , '2011/01/01') gives 18 days as date difference* select datediff(year, '2010/12/14' , '2011/01/01') gives 1year as date -- Rakesh Hendre, Sr. Software Architect Brilliance Software Systems. http://www.brilliancesoftwares.com/ Mob : 9960001862
