Forum Discussion
Solved
Local to UTC conversion (summer/ winter time)
Hy, another question for time appeared. I'm converting local to UTC time with summer/ winter time which works. At the end i make a text by startdate= DateTime.ToText(convertLOCALtoUTCWithDST(start)...
Hi alitzellachner ,
Please try replacing "hh" with "HH":startdate = DateTime.ToText(convertLOCALtoUTCWithDST(start), "yyyy-MM-ddTHH:mm:ssZ")Custom date and time format strings | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalI think you can directly use DateTimeZone.ToUtc or DateTimeZone.ToText