ParseUtc

Converts a UTC date to the equivalent local date using the system time zone.

Syntax: ParseUtc ( utc_UtcDate ) As Date

utc_UtcDate

required A Date value representing a point in time expressed in Coordinated Universal Time (UTC).

Returns a Date representing the same instant adjusted to the local time zone configured on the machine.

Remarks

On Windows, ParseUtc calls the Win32 GetTimeZoneInformation and SystemTimeToTzSpecificLocalTime APIs. The adjustment applies the machine’s current time-zone rules, as GetTimeZoneInformation reports them, to the date and time given by utc_UtcDate, so whether daylight saving time is in effect at the time of the call does not matter. The conversion works in whole seconds: a fraction of a second in utc_UtcDate is rounded to the nearest second.

Warning 2.3.1.1

A Date before 30 December 1899 gets the wrong day and time, and one before 1 January 1601 gives a meaningless date, with no error: Windows cannot convert it, and the function returns a date that bears no relation to the argument. Run-time error 10011 is not raised for it.

On macOS, ParseUtc invokes the system date command via a shell to perform the equivalent conversion.

An error during the conversion raises run-time error 10011 (“UTC parsing error”) with the source UtcConverter.ParseUtc.

ParseIso calls ParseUtc internally after it parses the date and time components of an ISO 8601 string.

Example

This example reads a UTC date, converts it to local time, and prints both values.

Dim utcDate As Date
Dim localDate As Date

utcDate = CDate("2024-06-15 12:00:00")
localDate = ParseUtc(utcDate)

Debug.Print "UTC:   " & utcDate
Debug.Print "Local: " & localDate

See Also

• ConvertToUtc function – converts a local date to UTC
• ParseIso function – parses an ISO 8601 string to a local date
• ConvertToIso function – formats a local date as an ISO 8601 string