Forum Discussion

Keshavpooja's avatar
Keshavpooja
Frequent Visitor
5 years ago
Solved

Convert column from Datetimezone to Datetime - M Query

Hi Experts,   I am getting values from the source like '2021-02-10 20:48:24 +01:00' which has been assigned type 'DateTimeZone' in the Query Editor. I would like to store it as 'DateTime' format wi...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this expression.

     

    = DateTimeZone.RemoveZone([DTZ]) + #duration(0, DateTimeZone.ZoneHours([DTZ]),0,0)

     

     

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Please try this expression.

 

= DateTimeZone.RemoveZone([DTZ]) + #duration(0, DateTimeZone.ZoneHours([DTZ]),0,0)

 

 

Pat

  • Keshavpooja's avatar
    Keshavpooja
    Frequent Visitor
    5 years ago

    Hi mahoneypat,

     

    That's superb. It works. Thanks a lot.

     

    //Kesavan.