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
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

You can switch your datetime columns to datetimezone type and use DateTimeZone.SwitchZone to match them up.

 

Pat