Sql Date ISDATE

ISDATE  function is used to check whether the date is valid or not.

Suppose you have a column nvarchar in which you are storing dates

select ISDATE(yourdate) from  YourTable

If Valid then it return 1  and if not then 0