Resulted In An Out-of-range Smalldatetime Valu

i get this error when running this sp: i think i should use convert method but how?

Msg 296, Level 16, State 3, Procedure CmmSPNet_userAlbumPhotos, Line 7

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'CmmSPNet_userAlbumPhotos' AND type = 'P')DROP PROCEDURE CmmSPNet_userAlbumPhotos

GOCREATE PROCEDURE [CmmSPNet_userAlbumPhotos]

@albumID int,

@orderBy varchar(100),

@orderDirection varchar(4)AS

SELECT ID,UserID,Photo,ALbumID,Title,views,date_added from cmmNet_userAlbumPic where albumID=@albumID order by

case @orderBywhen 'date_added' then case @orderDirection

when 'desc' then '31-dec-10' - date_added

/* highest date value */else date_added

endwhen 'views' then case @orderDirection

when 'desc' then 21474 - [views] /* highest integer value */else [views]

end

else date_added

end

GO