Convert yyyy-mm-dd to mmm-yyyy format

[psravani]

Hi All,

In alteryx formula tool, I am converting the date format of the Period column from the current yyyy-mm-dd to MMM-YYYY in the excel output using the following:

if IsString([Period])then
[Period]else datetimeformat(DateTimeParse([Period],"%Y-%m-%d"),"%b-%Y")
endif

The if condition is to include dates that have been mentioned as "Ongoing" in the Period column

But the output date still shows in YYYY-MM-DD format only in the excel output.

Please help!

Thanks,

Sravani

[binuacs]

@psravani 

DateTimeFormat(toDate([period]),"%b-%Y")