DateTimeZone.ZoneMinutes
The minutes part of a datetimezone's offset from UTC.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
DateTimeZone.ZoneMinutes(dateTimeZone as nullable datetimezone) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTimeZone | nullable datetimezone | The value; null gives null. |
Returns
nullable number. The minutes of the offset beyond its whole hours, with the offset's sign.
Remarks
- Most zones have whole-hour offsets, so this is usually 0.
Examples
India's +05:30
DateTimeZone.ZoneMinutes(#datetimezone(2024, 3, 15, 9, 0, 0, 5, 30))30Newfoundland's -03:30
DateTimeZone.ZoneMinutes(#datetimezone(2024, 3, 15, 9, 0, 0, -3, -30))-30