community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Quasar
Try this out!

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

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.

Thanks

Highlighted
Meteor

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 

Fireball

Sorry for the delayed reply, I didn't see this comment, can you provide some more sample data, I'm guessing the issue is that the month and day values aren't consistently 2 characters which will require some additional work to parse out and then convert to date format. If all the data is YYMMDD then you should be able to just use the Date conversion tool and set the input to that format and then use a second tool to convert the date field to whatever output you want.

Labels