This blog shows how to check if the given value is date or not using the ISDATE keyword in SQL query

Example:

SELECT ISDATE('1/1/20110')


The expected result would be 0 which means its not date value if a valid date is given it would return as 1