Now

returns the current date and time

The Now() function in Power FX returns the current date and time, making it ideal for situations where both the date and time are relevant.

It is useful for timestamps, real-time calculations, and handling time-sensitive actions.

Syntax

Now()

Since the format of DateTime data of the Alloy table is ISO 8601 formatted, while the Date Time data as the result of the syntax Now() is not, you will need to:

• convert the DateTime data of the Alloy table if you want to subtract the difference between it with Now()

DateDiff(DateValue(ThisItem.DateTimeColumn),Now(),TimeUnit[Unit]
or
DateDiff(DateTimeValue(ThisItem.DateTimeColumn),Now(),TimeUnit[Unit]

• convert the Date Time data with is the result of the syntax Today()to ISO 8601 format for the data representation in the app.

Text(Now(),"yyyy-MM-dd hh:mm:ss")

Example

If the current date and time is September 18, 2024, at 2:30 PM:

Syntax: Text(Now(),"yyyy-MM-dd hh:mm:ss")

Result: Sep 18, 2024, 2:30 PM