I think @lubos should really consider restricting date value storage and batch import / update to ISO format since it’s now natively supported by all major OS as well as spreadsheet apps.
I don’t think any more time should be wasted dealing with format inconsistencies when this entire situation can be avoided by standardization.