Downloads
Power Query MDate and timeAdvanced

DateTimeZone.UtcNow

Returns the current date and time in UTC, the universal reference time, with a zone offset of zero.

Syntax
DateTimeZone.UtcNow() as datetimezone

Returns: The current UTC time as a datetime with a time zone value.

What it does

DateTimeZone.UtcNow gives the current time in UTC. UTC is the reference that most systems use when they store a timestamp, whatever the local time. A bank, a payment processor or a cloud accounting API often records times in UTC. Knowing that a timestamp is UTC is what allows it to be converted to the local time of the business.

Syntax and arguments

Example

A team loads transactions from a system that stores every timestamp in UTC. The report run time is shown in UTC so the team knows which data cut it reflects.

let
    RunUtc = DateTimeZone.UtcNow(),
    RunLabel = DateTime.ToText(DateTime.From(RunUtc), "yyyy-MM-dd HH:mm", "en-US") & " UTC"
in
    RunLabel

The label shows the current UTC date and time, for example "2026-10-29 14:30 UTC". Because it is calculated at refresh time, it changes each time the report is refreshed.

Example: a second, different use

Compare two timestamps from different systems by converting both to UTC before the comparison, so a time zone difference does not look like a late posting.

Things to watch

In business terms

Cross border payments, global systems and cloud feeds all record time in UTC. Keeping the reference clear is how a team avoids a cut-off error where a payment appears to be on the wrong side of midnight.

Related functions

All Power Query M functions · View as Markdown · M basics