Newbie- Data conversion for V_string to date

Hi All,

I have a date coming in via Excel as Aug 15 2017. It is accepted into Alteryx as a V_string. I need to convert it to a date in yyyy-mm-dd format.

Converting via select tool or the DateTimeParse (tried DateTimeParse([Raw Date],"%Y/%m/%d")) results in nulls. Pls help

Thanks in advance

Meena

Date Time

Accepted answers

NJT

Josh's formula works DateTimeParse([Raw Date], "%b %d %Y") or you can use the DateTime tool as well but there's no way to convert the date in that format to a date using the select tool you have to format it first.

For the DateTime tool you'd just select convert string to date time format and select the Raw Date field as the field you want to convert. Then select Custom for the format of the incoming string field and enter the following Mon dd yyyy and that will get your date output.

See attached workflow for the two options.

Convert String to Date Aug 15 2017.yxmd

All comments

JoshKushner

Try this out!

DateTimeParse([Raw Date], "%b %d %Y")

NJT

See attached workflow for the two options.

Convert String to Date Aug 15 2017.yxmd

meenabalaji

Thanks

draghava

I have to convert "181028" as yy-mm- date but it shows fallowing error message . Can anyone help .

ConvError: DateTime (10): DateTime_Out: Cannot convert "181028 " to a date/time with format "%Y%m%d": Month number is out of range 1..12: '28 ' Record #7

Anuj_Sharma

Although, using formula is good option but I really liked your solution as it gives solution to not only this problem but any other problem, we will ever face related to date conversion.Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703