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

Options
AshfordLC
AshfordLC Member
in Archive

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

  • Chronos
    Chronos Member

    Is anyone able to help out with this request?

  • Jaketh13
    Jaketh13 Contributor

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


    Thanks,
    Jake
    **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"

Categories