|Type of Support:||Read & Write|
|Validated On:||2007, 2010, 2013, 2016, Online|
|Connection Type:||Alteryx Tools|
|Driver Details:||Register and obtain credentials from Microsoft SharePoint.|
Alteryx tools used to connect
SharePoint stores all DateTime values as UTC. To correctly convert your system's DateTime values to and from UTC, do the following:
- When writing to SharePoint, convert your system's timezone to UTC with the DateTimeToUTC() function.
- When reading from SharePoint, convert from UTC to your system's timezone with the DateTimeToLocal() function.
Otherwise, use another DateTime Function to perform the calculation. For additional information, see Functions.