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
Solved! Go to Solution.
Hi @Mj9715 ,
Maybe try using a datetimeformat function if you haven't already? It works fine for me when I tested
Thanks Angelos. This worked - I guess the format needs to be V_W String. I was trying on a date format column.