Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

export date in Excel in custom format yyyy-mm-dd;@

Highlighted

Hi everyone,

 

I have an issue with output data in Excel. Need the data in output file to be in Custom format yyyy-mm-dd;@ (is attached below)

Is it possible to do with Alteryx?

Also want to mention that I can apply macro in Excel because of certain peculiarities of further application of my file.

 

Would be grateful for consideration and any help

Highlighted
Alteryx Certified Partner

Hi @Ulyana_22 

 

The DateTime tool will enable you to specify a custom format for your dates. First make sure you have your dates formatted in YYYY-MM-DD format in a Date field type, then connect the DateTime tool and choose 'Date/Time format to string'. At the bottom of the page you can specify a custom format for your outputted date, which will now be in a String field.

Labels