My Solution attached. Not very elegant but I got there....
Thanks for this great date parsing challenge. Different date formats are a constant for me in everyday tasks so this is great practice!
I'm interested now to see if anyone completed this in < 5 tools!
AidanKing