Convert Date and Time string to Date and Time column using ETL's "Set Column Type"

Given a STRING column with a value as "1/13/2017 2:40:18 PM" I get error can't convert

upload

 Is it possible in ETL?

 

Comments

  • Is anyone able to help out with this request?

  • @AshfordLC That message generally means that the ETL is not encountering the format that it's expecting. One thing to double check is that you are setting the "What format is the date in?" to "Month first". From the example value you provided, it looks like that should be the one.