Ok, only a few years late to the party (probably a bit much to be socially late, I suppose :p) I did not read through the posts to see how others did this, as I like to struggle through on my own to figure it out, I learn more that way!
For me, I used a text to columns, then a multi field formula to get the mid characters of the two text fields. Converted the id column to int16 and then used a datetime tool to convert the date using a custom (dd-Mon-yy) format. a final select to remove the original date field and I had success 🙂
