when iam trying to delete records between two of different months its not deleting.

This is the code used :

If MsgBox(" Do You Want To Delete ", vbQuestion + vbYesNo, " DELETE BY DATE ") = vbYes Then
db.Execute "Delete from CTRAN where FWDate >='" & fdt.Text & "' And SWDate <='" & sdt.Text & "'"
MsgBox db.RecordsAffected & " Records Deleted "

This is deleting records between two diff dates of the same month.please help me out.