Hi all,
I have a workflow that produces an Excel file in which the date format is format to m/dd/yyyy . If I create a report, Alteryx changes the format to yyy-mm-dd. How can I change the settings back to m/dd/yyyy for the reporting.
The data type in Alteryx is Date.
Thanks,
Solved! Go to Solution.
Alteryx uses the standard ISO date format, but you can force it display a different style with a daretimeformat expression in a formula tool.
check out the documentation and let folks here know if you have questions.
Hi @wolfgangh ,
The format for date type columns will be always yyyy-mm-dd. To use other formats, you need to change the format to string and you can do that with a datetime tool as image and workflow attached.
Let me know if that works for you.
Best,
Fernando Vizcaino