You have a date stored as varchar or similar and you want to check it's a valid date?

Two options - the first being vastly more preferable:

(1) Don't store dates as varchar. Use one of the date data types.

(2) Use CONVERT to convert it to date. If it fails, you don't have a valid date. Use the TRY...CATCH syntax to trap errors.

John