Convert DD-MMM-YYYY to MM/DD/YYYY

I currently have a column (column 1) with dates in the following format: 01-JUL-2019. The select tool tells me Alteryx reads the dates as V_String. I want to create a new column (column 2) next to column 1 and convert all of the dates to the following format: 07/01/2019.

Can anyone help? Thank you!

Date Time

Accepted answers

fmvizcaino

Hi @JuanH ,

For that, you can use 2 datetime tool, one to transform your string into a date, then transform to your desired format.

Best,

Fernando Vizcaino

2020-09-09 Convert Date.yxmd

All comments

fmvizcaino

Hi @JuanH ,

For that, you can use 2 datetime tool, one to transform your string into a date, then transform to your desired format.

Best,

Fernando Vizcaino

2020-09-09 Convert Date.yxmd

grazitti_sapna

Hi @JuanH , try this solution as well.I hope this helps.

Thanks.

convert-date-GS.yxmd

GBO95

Hi @JuanH ,

The attached solution is also similar to all of the above.

Knowing the specifiers for the dates does the trick and you can check the help documentation for your reference:

https://help.alteryx.com/current/designer/datetime-functions

DateFormat.yxmd

JuanH

Thank you!

MATTHEW_KING1

Hi, is there any way to keep the data type as 'Date' on the new format? Seems all these end in the V_W String format. Which is not usable when then filtering by this column for anything date based.

Luke_C

@MATTHEW_KING1 No, in order to be treated as a date and work in date-based operations it must be in the Alteryx date format of yyyy-mm-dd.

MATTHEW_KING1

@Luke_C Thanks, so therefore it is impossible to output in a date format of mm/dd/yyyy once you have converted from a string to Alteryx date format? Seems restrictive. I understand the need for the format within Alteryx, but thought on output you could convert to any desired format?

Luke_C

@MATTHEW_KING1 You can format it however you want on the output, in Alteryx it would be a string. That's not to say that wherever you're outputting to wouldn't support (or require) a different date format.

amruthas2

@JuanH

Link for your future reference

DateTime Functions | Alteryx Help

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703