Since some_date is stored as VARCHAR(10), you should convert it into a DATE and filter out invalid values.

SELECT some_date FROM my_table WHERE TRY_CAST(some_date AS DATE) IS NULL;

Please store dates in DATE or DATETIME format instead of VARCHAR.

This will ensure the database enforces valid dates automatically.