I think you can do this in PowerQuery. I'm pretty sure Chandeep Chhabra covered it in one of his videos on youtube. basically, you have a translation...
other problem you have - in sql, when dates are expressed as a string they need to be in the format of mm/dd/yyyy or the sql standard of yyyy-mm-dd....