NOW
Returns the current date and time.
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
- NOW is recalculated each time it is used. Two visuals on the same page can show slightly different times.
- The time comes from the machine that runs the model or the service that hosts the report. It may not match your local time zone.
- For a report that must stay the same, store the run time as a fixed value at refresh, or use a parameter.
- DATEDIFF with HOUR or MINUTE uses the full datetime, so NOW and the load time must both carry a time part.
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.