Date exported by Render from Basic Table is not in date format

Hi, I use the Basic Table and then the Render tool to export result to excel files. So there's a field in basic table which is in date format. Now this date field get exported to the excel file but in string format, cannot be recognized as a date unless I edit each cell. What shall I do?

In this case, there're multiple sheets with different schema to be exported in one workbook, which is the reason I am not using the Output Data tool.

Reporting

Accepted answers

All comments

mceleavey

Hi @JokeFun ,

This is an Excel problem, not an Alteryx problem. Yet another reason to stop using Excel.

You can do the following to get around this:

1. Stop using Excel

2. Format your dates in Alteryx to be the format required by Excel, and let Excel then interpret the dates.

DawnDuong

Hi @JokeFun

you can try to format the date field (before the Table tool) to convert it into a String format that excel recognize. Eg. Instead of keeping the default format 2021-06-28 you can use the DatetimeTool to convert it to a string like 28–Jun-2021.

that works for me

cheers

Dawn

JokeFun

@DawnDuong Oops, it failed in my case. Still showing as text.

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335