Forum Discussion

Pallab_Kundu's avatar
Pallab_Kundu
Regular Visitor
7 years ago
Solved

Wrong Data in Time Zone calculation

Hi,   I have subtracted the two cloumn value which is Timezone formatted.Value as given below    Scenario 1 Custom=[#"Created (UTC)"]-[#"Date Reported (UTC)"] Created (UTC)=10/30/2018...
Need Help
Show and Tell
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Pallab_Kundu,

    For the first issue, based on my test, I suggest you create a calculated column in data view instead in query editor:

    For the second issue, I think the right answer shoud be 06:57:24? I think if the [Date Reported]=10/30/2018 7:35:00 AM +00:00, it could be 5:02:36, right?

     

     

    Regards,

    Daniel He

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Pallab_Kundu,

For the first issue, based on my test, I suggest you create a calculated column in data view instead in query editor:

For the second issue, I think the right answer shoud be 06:57:24? I think if the [Date Reported]=10/30/2018 7:35:00 AM +00:00, it could be 5:02:36, right?

 

 

Regards,

Daniel He