Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How do you set the date format in an excel output


I want my date fields to export in Excel in this format 26-Sep-2018.

Will someone please let me know what tool to use to do this?


Thank you. 

Alteryx Partner

You'll want to use the DateTimeFormat(field_string, format_string) function. Something like:


DateTimeFormat([Date], '%d-%b-%Y')


You can see the codes for all the different formats here.


Let me know if you need clarification.


I realize this is an old thread, but I need help here as well.


The solution you provided will output the date as a String, meaning Excel will not see it as a valid date (so no sorting, filtering, or formulas).


Is there a way to format the actual Excel cell to a specific date format?  Specifically, I am looking to keep the cell as a Date type, but when opening in Excel, it should display them as MM/dd/yy. Right now, Excel drops the leading 0 in months 01-09.