Converting Text With Date Time Zone to Date

Dear Experts

I need someone to guide me on how to convert Text contains time zone like this "Mon, 25 Oct 1999 16:06:00 -0700 (PDT)" Into Date "25-10-1999", Please note that I tried the available date conversion and convertx but I failed to change it into Date.

Thank you

Workflow

Date Time

Accepted answers

jdunkerley79

For Date you must use the later formula without the datetimeformat part.

Alteryx dates are just strings in yyyy-MM-dd format.

All comments

jdunkerley79

DateTimeFormat(
DateTimeParse(
trim(left([Input],16)),
"%a, %d %b %Y"),
"%d-%m-%Y")

This should do what you want.

- First get first 16 letters

- Parse to Alteryx date

- Format to string

Format Dates.yxmd

MAAbdullahAlMubarah

It gives me a NULL Value

MAAbdullahAlMubarah

Please check the file

challenge_134_solution_file.yxmd

MAAbdullahAlMubarah

If you convert the Output into String some of them will be NULL and the other will work correctly.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703