Date Conversion

,CASE
WHEN ISNUMERIC([SITE VISIT]) = 1
THEN CONVERT(SMALLDATETIME, (CAST([Site Visit] AS INT)), 101)
ELSE
CASE WHEN ISDATE([SITE VISIT]) = 1
THEN CONVERT(DATETIME, ([Site Visit]), 101)
ELSE '' END
END AS date_time