CMS shows incorrect time for users last login date

Joonas Kajava

Vote:

The CMS displays an incorrect Last login date/time for users because the CMS API appears to convert LastLoginDate to UTC even though the value is already stored in UTC in the database. This results in the displayed time being shifted (e.g., -2 hours).

I'm able to reproduce this bug easily.

When user logs in, their last login date is saved to database as UTC time.

The issue is that their last login date is shown as UTC time in the CMS:

The bug seems to originate from "/EPiServer/EPiServer.Cms.UI.Admin/users/GetUser?userName=bug" API which subtracts 2 hours from the last login (suggesting that this API treats already UTC time as local time):

CMS version: 12.34.1

#341587

Edited, Feb 02, 2026 9:49

Eric Herlitz

Vote:

Can you replicate this in multiple environments? E.g test, prod, your development box?

#341613

Feb 06, 2026 7:07

Joonas Kajava

Vote:

I can replicate this in local, test and production. Other projects also have this issue which suggests that this isn't project specific.

I've tried to change the timezone of the computer/server (and the db server), but that doesn't have any effect.

#341616

Feb 06, 2026 12:57

Eric Herlitz

Vote:

Just a thought, what coallition does your database use?

Check using

SELECT NAME, COLLATION_NAME FROM sys.Databases

#341664

Feb 11, 2026 14:30