Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date change between data out and reporting

wolfgangh
8 - Asteroid

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,

2 REPLIES 2
neilgallen
12 - Quasar

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
17 - Castor
17 - Castor

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.

 

fmvizcaino_0-1579060439723.png

 

Let me know if that works for you.

Best,

Fernando Vizcaino

Labels