Date Format to carry over to excel pivot

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

Date Time

Accepted answers

All comments

@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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703