Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add UTC offset to client time

Hi, i have some problems with UTC time.   Data in my reports is 2 hours less than real.   I tryed to convert hour to my timezone and it works but by this way i have hour +offest.   Example: 2...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Enter into Query Editor, Transform -> Date/Time/TimeZone. For example like picture below:

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

Enter into Query Editor, Transform -> Date/Time/TimeZone. For example like picture below:

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes but this only format column.

 

I dont want hour +offset. i only want hour.

 

Not 06/10/2019 11.20.00 +2.00 but i want 06/10/2019 13.20.00 .

 

 

Do you understand?

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Don't forget to click "Close &Apply".

     

    Best Regards,

    Amy