Am working with vb.net and Sql Server2000.on my program has to calculate the difference between two dates ,the result should be in months.ie RETIREDATE - HIREDDATE=number of months served.Surprisingly ,am getting ZERO months as a result.below is my code;

VB Code:
  1. Public Overloads Function DateDiff( _
  2.         ByVal Interval As DateInterval, _
  3.         ByVal Date1 As Date, _
  4.         ByVal Date2 As Date) As Integer


VB Code:
  1. Private Sub DateTimePicker3_ValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DateTimePicker3.ValueChanged
  2.         Dim service As integer
  3.         service = DateDiff(DateInterval.Month, DateTimePicker3.Value,  CDate(txtRetireDate.Text))
  4.         txtService.Text = service.ToString
  5.     End Sub
I am suspecting that the final statement (txtService.Text = service.ToString)might be the problem???
noteatetimepicker3 holds DATEHIRED.
Please help this urgently.!!!!!.I have been trying to figure it out in several ways to no avail.
I hope I will get a helpful support.thanks