Output date in MM/DD/YYYY format to excel file using table tool and render tool

[Ranjith_udaykumar]

Hi,

When I output a date filed using table tool and render tool to excel file, the date format changes to "Number" and  date  displays as 'YYYY-MM-DD' and excel filter does not show the dates grouped by year, month date. 

Instead the filter shows as below  (changes to text filter).

If we output the data using output tool to excel file, data comes as expected. Is there is a way to fix this in table and render tools?

[Kakuffo]

Hey

Is there a particular reason for the table tool to be used to create the output? Could the same output be achieved with the standard out puttool, seems to be alimitation of the table tool. 

Otherwise it may be worth utilising a VBS file using script.exe to add the filter function in after it has been exported. all depends on how comfortable you are with working with scripts.

[Ranjith_udaykumar]

The output tool does not produce excel reports with formatted text like heading, conditional formatting. 

[riyadh_jose · Accepted solution]

Sharing the solution I found.

It's a limitation of Excel to read Alteryx Date data as actual date when rendering. 

Solution: Select Data or Column of Data>Go to Data Tab>Select Text to Columns>Select Delimited and then click Finish.

Unable to get Excel to recognise date in column - Super User