<!-- https://learnsql.cpetoday.com/functions/dax/now -->
# NOW

Language: DAX
Category: Date and time
Syntax: NOW()
Summary: Returns the current date and time.
Returns: A datetime value.
Level: Beginner
Related: TODAY, TIME, DATE, DATEDIFF, YEARFRAC

## 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.

```dax
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.

```dax
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.
