Hi everybody. I am using the reports module to show a list of the last users who logged in. The only problem is that I am using a cloud server which is located in a different time zone so the times are always off. How can I correct this? My code is as follows:
Select
AU.Username,
U.FirstName,
U.LastName,
AM.loweredEmail as Email,
AM.LastLogindate as 'Date, Time is around 5 hours behind'
from
aspnet_Membership as AM with (nolock)
join aspnet_Users as AU with (nolock) on AM.UserID = AU.UserID
join Users as U with (nolock) on U.UserName = AU.Username
where
AM.ApplicationID = (select ApplicationID from dbo.aspnet_Applications where ApplicationName = 'DotNetNuke')
ORDER BY AM.LastLoginDate DESC

Thank you Sebastian Leupold you always come through1

i changed the 5 to a -5 and were all good