I have an excel file that contains data in the date format but it's of “String” data type. I need to upload this data into a database but before that, I need to cast the date from “String” to “Date” data type. I tried using tConvertType to perform this. But it is throwing an error saying:
java.text.ParseException: Unparseable date: "Tue Jul 17 00:00:00 EDT 1973"
Can someone point out what I am doing wrong?
Below is the screenshot of my job: