Forum Discussion
Convert UTC to local client timezone?
I saw support was added this month for UTCNOW and UTCToday...but that just returns the UTC value right? It does not take UTC time and convert it to the local time of whoever is viewing the report...
That is why (as you mentioned) the NOW does not work in the service.
What I need is to display data to the end users that was stored as UTC but needs to convert to their local timezone.
*Timesheet data or error log events, etc... stored UTC but need to go to local timezone of user viewing service.
How many users are you dealing with? If it's not huge, you could consider building a simple table of users and their default time zones, then using the username function, pull through who's using the report and have it look up and adjust your time fields accordingly?