Forum Discussion
Excel export always show date/time
I have data coming from MySQL through a query. I am displaying the data in a table and when I click on the export button. it exports the dates in the data as date/time format, Now in my MySQL query, ...
Select that Date/Time column, go to Add Column in Power Query > Date > Date Only.
Then delete the old column (date/time one) and apply changes. That always work for me.
Select that Date/Time column, go to Add Column in Power Query > Date > Date Only.
Then delete the old column (date/time one) and apply changes. That always work for me.