DateTimeZone.ToUtc
Shows a datetimezone's instant in UTC, with the offset +00:00.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
DateTimeZone.ToUtc(dateTimeZone as nullable datetimezone) as nullable datetimezone| Parameter | Type | Description |
|---|---|---|
dateTimeZone | nullable datetimezone | The value; null gives null. |
Returns
nullable datetimezone. The same instant in UTC.
Remarks
- The date may change as well: half past midnight in Oslo is still the day before in UTC.
Examples
An Oslo order in UTC
DateTimeZone.ToUtc(#datetimezone(2024, 3, 15, 14, 30, 0, 1, 0))#datetimezone(2024, 3, 15, 13, 30, 0, 0, 0)Just after midnight
DateTimeZone.ToUtc(#datetimezone(2024, 3, 15, 0, 30, 0, 1, 0))#datetimezone(2024, 3, 14, 23, 30, 0, 0, 0)Related functions
DateTimeZone.SwitchZone, DateTimeZone.UtcNow, DateTimeZone.RemoveZone.