Forum

Date formatting in ...
 
Notifications
Clear all

Date formatting in PQ

3 Posts
2 Users
0 Reactions
75 Views
(@charmainelindiquegmail-com)
Posts: 11
Eminent Member
Topic starter
 

When I go to "Using Local" and follow the step in the tutorial, my dates come up as yyyy/mm/dd and not dd/mm/yyyy as it does in the tutorial.  How do I fix this?

 
Posted : 03/08/2019 3:11 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Charmaine,

Welcome to the forum!

I suspect it's caused by some regional settings on your PC. This post explains more about Power Query date settings.

Mynda

 
Posted : 03/08/2019 4:14 am
(@charmainelindiquegmail-com)
Posts: 11
Eminent Member
Topic starter
 

Thank you Mynda,  I thought I was perhaps doing something wrong.  I will get IT to change the operating systems format for me.

 
Posted : 04/08/2019 2:54 am
Share: