Convert date to DDMMYYY format for csv output

[shilpamehta1991]

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.

[Aidan_K · Accepted solution]

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

[shilpamehta1991]

Thanks @AidanKing for your solution. It works.  

[Aidan_K]

Your welcome @shilpamehta1991.

Happy to help :)

Regards,

Aidan

[MarqueeCrew]

An alternative solution is to use the datetimeformat function in a formula.

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

Cheers,

Mark