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

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?

Developer Tools

Accepted answers

riyadh_jose

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

All comments

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

Sharing the solution I found.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235