I think following this guidance in our documentation would be your best option. It details how to instantiate UnexpectedRowsExpectation
to define a custom Expectation. In your case you could create a subclass of UnexpectedRowsExpectation
and implement the SQL logic that validates whether the rows in a column conform to your expected date format.