Date Problem in sql Server 2008 R2

[jackaal]

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]....

here is my query....

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

Thanks...

[Rabbit]

Please use code tags when posting code.

Dates should be compared as dates, not strings. If you're going to convert dates to strings, then you need to put the string in a format where the unit of time goes from largest to smallest from left to right.

[ck9663]

Here, read this...

Good Luck!!!


~~ CK