CODE EXAMPLE FOR SQL

sql find record cannot cast date

select * from tableXX
where TRY_CAST(columndateXX as date) is null