Datetimezone Functions Overview

Discover Datetimezone Functions in Power Query M Language, crucial for handling date, time and timezone values. This page provides a comprehensive list and descriptions of Datetimezone Functions available in the M Language.

Component Functions

Function	Description	Input	Output
DateTimeZone.ZoneHours	Changes the timezone of the value.	Datetimezone	Number
DateTimeZone.ZoneMinutes	Changes the timezone of the value.	Datetimezone	Number

Creation and Conversion Functions

Function	Description	Input	Output
#datetimezone	Creates a datetimezone value from numbers representing the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes.	Number	Datetimezone
DateTimeZone.From	Creates a datetimezone from the given value.	Any	Datetimezone
DateTimeZone.FromFileTime	Creates a datetimezone from a 64 bits long number.	Number	Datetimezone
DateTimeZone.FromText	Creates a datetimezone from local, universal, and custom datetimezone formats.	Text	Datetimezone
DateTimeZone.ToLocal	Converts the timezone component to the local timezone.	Datetimezone	Datetimezone
DateTimeZone.ToRecord	Returns a record containing the datetimezone value’s parts.	Datetimezone	Record
DateTimeZone.ToText	Returns a textual representation of the datetimezone value.	Datetimezone	Text
DateTimeZone.ToUtc	Converts the timezone component to UTC timezone.	Datetimezone	Datetimezone

Current Value Functions

Function	Description	Input	Output
DateTimeZone.FixedLocalNow	Returns the current date & time in the local timezone	Datetimezone	Datetimezone
DateTimeZone.FixedUtcNow	Returns the current date and time in UTC (the GMT timezone)	Datetimezone	Datetimezone
DateTimeZone.LocalNow	Returns the current date & time in the local timezone.	Datetimezone	Datetimezone
DateTimeZone.UtcNow	Returns the current date and time in UTC (the GMT timezone).	Datetimezone	Datetimezone

Modification Functions

Function	Description	Input	Output
DateTimeZone.RemoveZone	Removes timezone information from the given datetimezone value.	Datetimezone	Datetime
DateTimeZone.SwitchZone	Changes the timezone of the value.	Datetimezone	Datetimezone

Last update: November 24, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetimezone-functions
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.