List of DateTime Property and DateTimeKind

klappo

Vote:

I am trying to update page property programmatically.

The type of the property is IList<DateTime>.

The source list of dates contains only UTC dates (DateTimeKind.Utc)

After saving changes and re-reading page object it turns out that all dates are converted to Local time

The question is: what a heck?

Code demo is below.

List<DateTime> newDays = GetDays(); // all UTC dates, 

HomePage page = _contentLoader.Get<HomePage>(pageRefHere);
var clone = page.CreateWritableClone() as HomePage;
clone.SpecialDateTimes = newDays; // SpecialDateTimes is still in utc here
_contentRepository.Save(clone, SaveAction.Publish, AccessLevel.NoAccess);

page = _contentLoader.Get<HomePage>(pageRefHere); // re-read page 

var days = page.SpecialDateTimes; // all dates are local now

#282312

Edited, Jun 23, 2022 8:58

Scott Reed

Vote:

It's usual for any dates shown in the UI to be converted in to the local users time based on their locale settings so if you're seeing this in the CMS backend that's quite normal.

Dates in the database should be saved as UTC then the UI takes care of localization for users.

#282313

Jun 23, 2022 9:11

klappo

Vote:

> It's usual for any dates shown in the UI

I can't argue with that, but I am getting the page on backend part to do calculations and I guess it is more convinient to work with universal time

Convertion to local time should be on FE part, just as you said.

#282314

Edited, Jun 23, 2022 9:29

Scott Reed

Vote:

One thing missing in your code is the actual Saving / Publishing code that should be after clone.SpecialDateTimes = newDays;

Just in case you're seeing weird behavior as you've not actually saved it you should add that in, where below _repository is IContentRepository

_repository.Save(page, SaveAction.Publish);

#282315

Jun 23, 2022 9:33

klappo - Jun 23, 2022 10:00

you are right, but it doesn't change much in the topic

Scott Reed - Jun 23, 2022 10:02

The APIs I believe convert to UTC based on the server setup. So there's a chance that not doing saving or publish hadn't gone through those processes ergo I thought it would be relevent. It might be if your local server time isn't UTC it might be attempting to convert

klappo - Jun 23, 2022 10:07

> it might be attempting to convert
and again, I don't see a good reason why it does so on BE part. I could understand if that happened on FE side of even may be in ContentDeliveryApi

klappo

Vote:

List<DateTime> newDays = GetDays(); // all UTC dates, 

HomePage page = _contentLoader.Get<HomePage>(pageRefHere);
var clone = page.CreateWritableClone() as HomePage;
clone.SpecialDateTimes = newDays; // SpecialDateTimes is still in utc here
 _contentRepository.Save(clone, SaveAction.Publish, AccessLevel.NoAccess);

page = _contentLoader.Get<HomePage>(pageRefHere); // re-read page 

var days = page.SpecialDateTimes; // all dates are local now

updated code example

#282318

Jun 23, 2022 10:01

klappo

Vote:

no solution

#283986

Jul 20, 2022 7:42