Power Query
published
Search
⌃K

DateTime.AddZone

DateTime.AddZone

Sets timezone information on the datetime value.
function (optional dateTime as nullable any, timezoneHours as number, optional timezoneMinutes as nullable any) as nullable any

Description

Sets timezone information to on the datetime value dateTime. The timezone information will include timezoneHours and optionally timezoneMinutes.

Category

DateTime

Examples

Set timezone information for #datetime(2010, 12, 31, 11, 56, 02) to 7 hours, 30 minutes.
DateTime.AddZone(#datetime(2010, 12, 31, 11, 56, 02), 7, 30)

datetimezone(2010, 12, 31, 11, 56, 2, 7, 30)