This content has been marked as final. Show 3 replies
There is a dimension called system time in the dataset.
The data format is like "29/06/2016 06:14:08" which the time is in US timezone.
I would like to create a calculated field called local time to show the corresponding UK time of the system time.
i.e. US time + 5 hours ahead.
In the example, the tme of local time would be "29/06/2016 11:14:08".
I tried the MAKEDATETIME function but it didn't work well.
Would you please let me know what the best solution would be?