NOW
The date and time now, by the clock of the computer the engine runs on, read once for the whole query.
Group: Date and time. Compatible with DAX.
Syntax
NOW ( )It takes no parameters.
Returns
Date and time. The current date and time on the computer that runs the engine.
Remarks
- The clock is read once per query: every NOW in it, on every row, gives the same instant, and
UTCNOWgives that instant in UTC. - It is the time in that computer's own time zone, which need not be the reader's. A server in another zone, or a service that runs on UTC, shows its own time.
- For the date alone, use
TODAY; for the time of day alone,NOW () - TODAY (). - The examples show the moment their page was built.
Examples
The time now
EVALUATE
ROW ( "Now", NOW () )| Now |
|---|
| 2026-11-02 23:04:59.85 |
Hours since midnight
EVALUATE
ROW ( "Hours since midnight", ROUND ( ( NOW () - TODAY () ) * 24, 2 ) )| Hours since midnight |
|---|
| 23.08 |