DateTimes are local and not UTC

[bhas]

Category

• Bug

Describe the bug

DateTime values are returned in local DateKind instead of Utc, when reading SharePoint List items data, even when DatesInUtc = true.

Tip

I did some investigation and it looks like the issue happens with this line when trying to parse the DateTime object from the JSON. DateTime.TryParse converts the date into local time per default. It looks like you can use this code to have the parsed DateTime be in UTC instead:

DateTime.TryParse(dateString, null, System.Globalization.DateTimeStyles.AdjustToUniversal, out _);

Steps to reproduce

1. Load any date column from a view with DatesInUtc = true such as:

var output = await list.LoadListDataAsStreamAsync(new RenderListDataOptions
{
    ViewXml = viewXmlQuery,
    RenderOptions = RenderListDataOptionsFlags.ListData,
    DatesInUtc = true,
});

var item = list.Items.AsRequested().First();
var date = item.Values["ConfirmedDate"]; // here date.Kind == Local

1. Inspect that the returned DateTime object has Kind = Local

Expected behavior

When loading data with the argument is DatesInUtc = true I would expect to receive a UTC dates back and not Local dates.

Environment details (development & target environment)

• SDK version: 1.9.0
• OS: Windows 10
• SDK used in: ASP.Net Web app
• Framework: .NET Core v8.x