How do i parse this date to datetime?

I have a column with time in the format: 17 Jul 2019 11:15:16, it's in string format how do i parse to datetime? I have tried to specifiy the format using the parse function but it doesn't seem to be working. e..g i would like in format 17:07:2019 11:15:16

Parse

Date Time

Data Investigation

Accepted answers

A good solution from @LordNeilLord. His formula will convert your input to the format that Alteryx uses internally "2019-07-17 11:15:16". If you need to do any date time manipulations, adding intervals, comparing dates, extracting the year, etc, this is the format that the date will need to be in.

If you want your field in the format 17:07:2019 11:15:16, then you have to add another step.

datetimeformat([Field1],"%d:%m:%Y %H:%M:%S")

This will create a string field that you can use for output or display

Dan

All comments

It's DateTimeParse([Field1],"%d %b %Y %H:%M:%S")

A good solution from @LordNeilLord. His formula will convert your input to the format that Alteryx uses internally "2019-07-17 11:15:16". If you need to do any date time manipulations, adding intervals, comparing dates, extracting the year, etc, this is the format that the date will need to be in.

If you want your field in the format 17:07:2019 11:15:16, then you have to add another step.

datetimeformat([Field1],"%d:%m:%Y %H:%M:%S")

This will create a string field that you can use for output or display

Dan

Totally didn't read the second part of that post

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703