Forum

Losing date formatt...
 
Notifications
Clear all

Losing date formatting when filtering dates in query

2 Posts
2 Users
0 Reactions
80 Views
(@mforan14)
Posts: 1
New Member
Topic starter
 

Hi Mynda,

I am doing your exercise pg_4.07: filter the dates in query editor (select Jan only), then close & upload.  All works fine

When I go back to query editor and remove the filter, then close & upload, all the date formatting has been removed on my excel spreadsheet for OrderDate, RequiredDate & ShippedDate

Thanks, Michael

Lose-date-formatting.png

 
Posted : 21/03/2017 3:56 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Michael,

I suspect the data type for those fields isn't set to Date in Power Query?

Mynda

 
Posted : 21/03/2017 8:29 pm
Share: