3 Replies Latest reply on Jul 1, 2016 9:19 AM by Shinichiro Murakami

    Create a calculated field for date & time

    Winson Lui
    Winson Lui Jul 1, 2016 7:57 AM

      HI,

       

      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?

      Thanks.