Designer| Date format conversions

[Mj9715]

Hi All

I have a column with dates shown below - in the format of %Y %m %d . I need to convert it to mmm-yy format i.e., %b %y format in Alteryx. However when I try date time parse or other date time formats on the date column, I get returned null values. 

Can someone suggest a better way to convert the existing column to desired format?

2000-01-01

2000-02-01 

[AngelosPachis · Accepted solution]

Hi @Mj9715 ,

Maybe try using a datetimeformat function if you haven't already? It works fine for me when I tested

[Mj9715]

Thanks Angelos. This worked - I guess the format needs to be V_W String. I was trying on a date format column.