Forum Discussion
Help with parsing a date, time and timezone column
Hi mouse_art,
Thanks for reaching out!
You're right, Power Query's DateTimeZone.FromText does not support parsing time zone abbreviations like CEST or CET directly using a format string. These abbreviations are ambiguous and aren't currently recognized by the DateTimeZone.FromText parser.
A recommended approach would be to:
- Extract the time zone abbreviation from your string,
- Map it to a corresponding UTC offset (e.g., CEST -> +02:00),
- Rebuild your datetime string in a standard format (like ISO 8601),
- And then pass it to DateTimeZone.FromText.
Hope this helps, If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you for using Microsoft Fabric Community Forum.
Helper V
I have tried to suggest a solution, but could find the thread to reply
You can try this
= Table.AddColumn(#"Type modifié", "date", each
let
txt = [Raw],
dt = DateTime.FromText(Text.Start(txt, Text.Length(txt) - 5)),
tz = Text.End(txt, 4),
offset = if tz = "CEST" then 2
else if tz = "CET" then 1
else 0,
dtz = DateTimeZone.SwitchZone(DateTimeZone.From(dt), offset)
in
dtz
)The column Raw contains "10 Sep 2024 3:51 PM CEST" and it adds a column [date] displaying 10/09/2024 16:51:00 +02:00 as datetimezone
If this helps, please consider accepting this as a solution as well and give kudos 🙂