← Back to DateTimeZone functions

DateTimeZone.RemoveZone

This function obtains a #datetime value from dateTimeZone, excluding the timezone information.

Syntax

DateTimeZone.RemoveZone(dateTimeZone as nullable datetimezone) as nullable datetime

About

This function obtains a #datetime value from dateTimeZone, excluding the timezone information.

Explanation

Extract the timezone data from the value #datetimezone(2011, 12, 31, 9, 15, 36, -7, 0). To do this in Power Query, use the function MDateTimeZone.RemoveZone(#datetimezone(2011, 12, 31, 9, 15, 36, -7, 0)). The result will be #datetime(2011, 12, 31, 9, 15, 36).