Forum Discussion
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)...
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:
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.
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).