WHEN @Data_Type IN ('char','varchar','nchar','nvarchar')
->
WHEN @Data_Type IN ('char','varchar','nchar','nvarchar','date')
currently dates generate unquoted which sql server will not convert to date
(could also cast or convert to date but believe it is never required for date)