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.
Solved! Go to Solution.
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
Thanks @AidanKing for your solution. It works.