Forum Discussion
Solved
Display UTC datetime in client's local timezone
In my dataset, I've got datetime values stored in UTC. I need to display it in the client's local time. Is there a way to for reports published to the service to display the UTC datetime in my client...
Hey nwrong ,
unfortunately, this is not possible.
But maybe you might consider this idea.
Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.
Regards,
Tom
Hey nwrong ,
unfortunately, this is not possible.
But maybe you might consider this idea.
Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.
Regards,
Tom
Thanks Tom,
that is a good alternative. I'll give it a go.
- Did it work?
