SqlServer 2008 R2

Question

Hello Friends,

I have some problem in sql server.

i created a storeprocedure with compare table [column] date witch difine varchar() and compare to getdate(). when compare it not proper work it gives only current month proper result not[previous or next month]....

update tablename

set DatalinkStatus='Visit Not Successfully' where convert(varchar(10),CallingDateAgree,103)<convert(varchar(10),getdate(),103) and status='disable'

Thanks...