Date Format to carry over to excel pivot

[bdelarosa]

I run a workflow thru alteryx to an sql database and use excel to read the database to create a pivot, but the date format doesn't carry over. I get funky formats. using alteryx i have it as "DATE FORMAT".  Anybody know how to solve this issue? Thanks 

[Qiu]

@bdelarosa 
You mean yyyy-mm-dd format.

This is alreryx standard date format.

---

Alteryx uses the ISO format yyyy-mm-dd HH:MM:SS to represent dates and times

---

[bdelarosa]

What format it need to be for excel to read it? excel reads it as junk

[Qiu]

@bdelarosa 
What format are you outputting data from Alteryx?

[bdelarosa]

[AlbertP1]

Go to Excel and check the data format of these 'Date' Cells (CTRL-1). Make sure they are in the Date Category.