Date change between data out and reporting

Question

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,

fmvizcaino · Accepted Answer

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