Downloads
DAXDate and timeBeginner

NOW

Returns the current date and time.

Syntax
NOW()

Returns: A datetime value.

What it does

NOW returns the current date and the current time together. Finance teams use it for the "generated at" stamp on a report, for checking how old the latest bank or ERP feed is, and for timing controls such as the hours a batch has been waiting. Like TODAY, it changes every time it is evaluated, so the value shown depends on when the report is opened or refreshed.

Syntax and arguments

NOW takes no arguments. Write it with empty parentheses: NOW().

Example

A close pack should state when the numbers were produced, so a reviewer can see whether the figures are current. A card on the report page shows the time.

Report Generated =
"Generated " & FORMAT(NOW(), "yyyy-mm-dd hh:mm")

The result looks like "Generated 2026-10-29 16:45". FORMAT turns the datetime into readable text with the year, month, day, hour and minute.

Example: a second, different use

A control check that flags a bank feed as stale when its last load is more than 12 hours old. The measure counts whole hours between the last load and now.

Feed Age (hours) = DATEDIFF(MAX('Bank_Feed'[LoadedAt]), NOW(), HOUR)

Things to watch

In business terms

NOW supports audit trails, "as of" stamps on financial packs, data freshness checks on bank and payroll feeds, and the time-based controls that watch batch jobs and approvals. Auditors often ask when a report was produced, so the stamp belongs on the page.

Related functions

All DAX functions · View as Markdown · DAX fundamentals