Use a string splitter to split each date into its individual elements, and keep those that have four characters and can be converted to a number between, say, 1950 and 2050.

Please tell me you're doing this as a one-off to clean your data and that you're not persisting with storing date values in that way?

John