TODAY

Today's date, by the clock of the computer the engine runs on, read once for the whole query.

Group: Date and time. Compatible with DAX.

Syntax

TODAY ( )

It takes no parameters.

Returns

Date. Today's date on the computer that runs the engine, at midnight.

Remarks

• The clock is read once per query, so TODAY is the same on every row; it equals INT ( NOW () ).
• It is today in that computer's time zone. Near midnight, UTCTODAY can be a day earlier or later.
• A measure with TODAY moves with the calendar: the same query gives another answer tomorrow.
• The examples show the day their page was built.

Examples

Today, and the month around it

EVALUATE
ROW (
    "Today", TODAY (),
    "First of the month", DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ),
    "End of the month", EOMONTH ( TODAY (), 0 )
)

Days to each bond's maturity

EVALUATE
SELECTCOLUMNS (
    Holdings,
    "Bond", Holdings[Bond],
    "Days left", INT ( Holdings[Maturity] - TODAY () )
)

Related functions

NOW, UTCTODAY, DATE, EOMONTH, DATESBETWEEN.

Last updated 3 November 2026 · OpenBI Studio 0.3.74