I faced this when developing SSRS report when user put period from 1/2/2012 to 31/12/2012. note this date in “dd/MM/yyyy” format, when passing these two dates to DateDiff() SQL function the result will be 10 months. DATEDIFF(month, ’2/1/2012′, ’12/31/2012′) This…