Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sharepoint Date Format - Regional Settings - Locale issue

Hello   I want to create two Queries in the same workbook where one query links to a Sharepoint with US locale (date/region format) and the other to a Sharepoint with EU locale (date/region format)...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi Anonymous ,

See:

Table.TransformColumnTypes(table as table, typeTransformations as list, optional culture as nullable text) as table

You can use the specified culture in the optional parameter culture (for example, "en-US"). 

 

In this issue, if the default type of EU date is text, you can try like this:

= Table.TransformColumnTypes(#"Changed Type", {{"Column3", type date}}, "en-GB")

 

 

Refer:

  1. Table.TransformColumnTypes()
  2. Flawless Date Conversion in Power Query 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    v-yingjl  thanks I will try that although to be honest I saw several posts of this and the conclusion seems to be that it's a bug of the Api 15 (it works with Api 14).