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
DateTimeFormat(toDate([period]),"%b-%Y")