Forum Discussion
Advocate IISharepoint.Files returns Error for datetime fields as of March 2018 version
Microsoft EmployeeHi eFeM135,
Please try to change the Locale in desktop (File->Options and settings->Options) to fit the datetime format.
Regards,
Yuliana Gu
Advocate IIThis is an unacceptable workaround, as this would mean that I need to translate all the other date- and number- fields which are matching my regional settings (nl-NL) using the optional locale parameter.
The API from Sharepoint.Files either uses a hardcoded 'en-US' locale and returns a valid date (not a text in US-format which I need to transform like I currently do), or provides an optional locale as we have for most of the M-script variants.
BTW: I also need to shift the datetime with -8 hours from US-California time to CET... another 'feature' from this API. I strongly suggest to let the product team have a look at this - what I call a - BUG.
- eFeM135
I'm being whether my problem is solved, with a handful people having viewed my posting... wondering whether I'm on the wrong forum or whether the issue is not understood. Assuming the latter: The first extract is in 'working' the february version, the second with the march version:
Nevertheless the february version is not 100% as is returns text in a datetimezone field, I still can work through it... but I cannot do anything with 'Error'...
Note the issue is not only regionalization but also timezone related... IMHO these should both be handled by optional parameters in the Sharepoint.Files function