CODE EXAMPLE FOR SQL

find invalid datetime field

SELECT ISDATE(BirthDate) AS IsValidDate FROM Person