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
thx but in this case i get the same result "2023-03-01T06:00:00Z" and no distinction between summer and winter time. So the problem is the transformation ToText
start= 01.03.2023 20:00:00 +02:00
= DateTimeZone.ToText(DateTimeZone.ToUtc(start), "yyyy-MM-ddThh:mm:ssZ")