Alteryx Designer

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

Convert date to DDMMYYY format for csv output

Highlighted
Alteryx Partner

I need to output file in csv and want the dates to be in DDMMYYYY format instead of YYYY-MM-DD the standard format of Alteryx.

Please suggest how can I do this.

Highlighted
9 - Comet

Hi @shilpamehta1991 

 

You could use a formula tool to do this.

from 2019-01-01 to 01012019 using (e.g.) Right([Date A], 2)+""+Substring([Date A],5,2)+""+Left([Date A], 4)

 

See sample workflow attached.

Regards,

Aidan

Highlighted
Alteryx Partner

Thanks @AidanKing for your solution. It works.  

Highlighted
9 - Comet

Your welcome @shilpamehta1991.

 

Happy to help :)

 

Regards,

Aidan

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
An alternative solution is to use the datetimeformat function in a formula.

DateTimeFormat([date],"%d%m%Y")

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels