Forum Discussion

Girts's avatar
Girts
Frequent Visitor
8 years ago
Solved

Date format conversion to local does not works properly

There exist functionality which allows changing data type - in my case after unpivot date columns I got date values as text.  I tried to change the type to local date format (Latvian) ... but...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Girts,

     

    By my tests, I cannot reproduce your issue in my site. 

    Maybe you could have another try with setting the locale region settings of your system?

    Normally, Date Type conversion can be tricky depends on the locale of system you are working on. 

     

    For more details, you could have a look at this blog which introduce the ways about Date Conversion in Power Query.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Girts,

 

By my tests, I cannot reproduce your issue in my site. 

Maybe you could have another try with setting the locale region settings of your system?

Normally, Date Type conversion can be tricky depends on the locale of system you are working on. 

 

For more details, you could have a look at this blog which introduce the ways about Date Conversion in Power Query.

 

Best Regards,

Cherry