-werners-
Esteemed Contributor III

How about not specifying the format?  This will already match common formats.
When you still have nulls, you can use your list with known exotic formats.
Another solution is working with regular expressions.  looking for 2 digit numbers not larger than 12 probably means it is the month. the other 2 digit number is day etc.
This is where regex shines.