We are having trouble importing from xlsx files that sometimes the date is imported incorrectly e.g. 18/6/2016 was imported as 1/9/4253 when the source file was xlsx instead of csv. Most recently this has happening with gift date and action completed date.
I would like to use RegEx and the Skip Row exception to prevent such imports but am a beginner with regular expressions and don't know where to start. Just rejecting dates that do not have the year of 2016 or 2017 would be great. I don't mind updating the dictionary once a year.