DECLARE @foodate VARCHAR(10)
SET @foodate = CONVERT(VARCHAR(10),CURRENT_DATE)
SET date = CONVERT(VARCHAR(10),CURRENT_DATE)
WHERE @date <> @foodate
This assumes your formatting of the varchar date column in rtm_customerservice matches the smalldatetime format of the CURRENT_TIME system variable.
If not you have some gluing and sticking ahead of you...