hii 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 difference
kindly do help to find out the perfect datediff -- Rakesh Hendre, Sr. Software Architect Brilliance Software Systems. http://www.brilliancesoftwares.com/ Mob : 9960001862
