I am not sure if there was an easier way to change the format of shipping date from string to date. I used following steps to convert:
(i) Text to columns: split on /
(ii) Formula to create a new Date column: combined the 3 split columns starting from [Year]+"-"+[Month]+"-"+[Day]
I tried changing from Select tool but it was giving me error.
Any suggestion.