DateTime.FixedLocalNow

DateTime.FixedLocalNow is a Power Query M function that returns a datetime value set to the current date and time on the system, which is fixed and will not change with successive calls.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DateTime.FixedLocalNow() as datetime

Description

Returns a datetime value set to the current date and time on the system. This value is fixed and will not change with successive calls, unlike DateTime.LocalNow, which may return different values over the course of execution of an expression.

Examples

Let’s see an example of the DateTime.FixedLocal now function. Here’s the output of this function at the moment it was run: 

DateTime.FixedLocalNow() 

// At the time of running this query the function returns
// #datetimezone( 2023, 7, 23, 12, 56, 24.0738740)
// represented by: 2023-07-23T12:56:24.0738740

Other functions related to DateTime.FixedLocalNow are:

BI Gorilla Youtube Channel

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetime-fixedlocalnow
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.