Hi,
try this
declare @D1 date
declare @D2 date
set @D1='15-june-2013'
set @D2 ='15-apr-2013'
if DATEDIFF(day,@D1,@D2) > 0
(
select 'first date is lesser then second'
)
else if DATEDIFF(day,@D1,@D2) < 0
(
select 'second date is lesser then first'
)
else if DATEDIFF(day,@D1,@D2) = 0
(
select 'Both date are same'
)
I hope this will help you... :)