DateTimeZone.From Function in Power Query
The DateTimeZone.From function converts a given value into a datetimezone type, which includes both date/time and timezone offset information.
Syntax
DateTimeZone.From(value as any, optional culture as nullable text) as nullable datetimezone
The parameter value is a required parameter and can be:
- date: A datetimezone with value as the date component, 12:00:00 AM as the time component, and the offset corresponding the local time zone.
- text: A datetimezone value from textual representation.
Example:
Power Query M
let Source = DateTimeZone.From(#date(2025, 4, 12)) in Source
The output of the above code 12-04-2025 00:00:00 +05:30.