Date change between data out and reporting

[wolfgangh]

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,

[wolfgangh]

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,

[neilgallen]

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. 

[fmvizcaino · Accepted solution]

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