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


 Is it possible in ETL?



  • Is anyone able to help out with this request?

  • Jaketh13
    Jaketh13 Domo Employee

    @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.

    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"