Hi,

In the SP aspnet_Membership_UpdateUser the LastActivityDate is in UTC.

Can I somehow change that into UTC+2?

Or even better adapt it according to the Local situation? (i.e. change to DST and back)

Thanks in advance,

Lx

If the LastActivityDate is in UTC then the the value most likely came from the function GetUTCDATE - this needs to be changed to GetDate() which will put in the local date/time. It will probably be in the SP aspnet_Membership_UpdateUser, just change GetUTCDATE to GetDate.

There may be some knock-on effects, which not knowing that particular database system, I cannot comment upon.