Converting V_string column to date variable?

Question

Hi Everyone

I'm new with alteryx.

I hope someone can help me with my scenario.

I have a column named "Weekday_new" . The data type assigned on this column is V_WString and I want to convert it to date.

For the sampledata please see below:

As you can see the Weekday_new column is in 31-August-20 format.

That data is correct however I want to change it to date type

How can I do it?

Thanks in advance everyone

Cheers!

grazitti_sapna · Answer

Hi @Rinkashime , by default alteryx accepts yyyy-mm-dd as default date format. The format you are using i.e "31-August-20" is a custom format and is assigned V_String datatype. If you are looking to convert it into date format it will be displayed as 2020-08-31.

Thanks.

Qiu · Answer

@Rinkashime 
you can use datatime tool or DateTimeParse.
@atcodedog05 
you are so fast!!

1006-Rinkashime.yxmd

atcodedog05 · Answer

Hi @Rinkashime ,

Alteryx accepts only 2020-10-01 as the correct date format. To easily convert any other format to date type use the DateTime tool.

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

Interactive lesson: https://community.alteryx.com/t5/Interactive-Lessons/DateTime-Functions/ta-p/98952

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍