Date Inconsistencies messes up Data Import feature

While importing data the import feature gets all messed up if there is an inconsistent date (such as 29-02-2015 or 30-06-2015, etc.)

The routine actually imports till the inconsistent date is encountered, but the onscreen message does not indicate this.

It would be great if you guys could find the bandwidth to fix this.

I’ve come across this as well. It seems to be detecting dates from 1950’s and 60’s as 2050’s and 2060’s. As a result when I upload employee records with birth years between 1950 and 1970, it shows me date of birth cannot be after current date.

Fixed it by formatting date as dd/mm/yyyy in Excel instead of the default dd/mm/yy