DateTime.AddZone
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.
DateTime.AddZone(dateTime as nullable datetime, timezoneHours as number, optional timezoneMinutes as nullable number) as nullable datetimezone
| Argument | Description |
|---|---|
| dateTime | A DateTime to modify. |
| timezoneHours | The hours to add. |
| optional timezoneMinutes | The minuts to add. |
DateTime.AddZone(#datetime(2010, 5, 4, 6, 5, 5), 8) equals #datetimezone(2010, 5, 4, 6, 5, 5, 8, 0)
Show: