I realised after I could've used StripQuotes[(String)] instead of having to use a data cleanse and formula (left & right) which would've tidied up the solution!
Previously I used the long method to solve this challenge, I used two regex to replace the comas and datetime tool to convert string into date, later I thought its a lengthy way to solve so I modified and used formula tool to solve this problem. PFA the solution