Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

HOJE

On this page (10)

Today's date.

FieldValue
CategoryDate and time
TypeScalar (operates value by value)
Arityno arguments
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: HOJE. Accepted aliases (case-insensitive): today.

Syntax#

code
HOJE()

All arguments are expressions.

Returns#

Date.

Null handling#

Invalid or missing dates become a friendly error or blank, depending on the function.

Evaluation context#

Scalar — evaluated on the result of the arguments (in calculated columns, it runs row by row).

Differences from DAX#

  • DAX equivalent: TODAY
  • Compatibility: DIFFERS from DAX — different semantics, watch out
  • Note: Uses the America/Sao_Paulo time zone; DAX TODAY uses the service's time zone (typically UTC).

Examples#

code
DATADIF(pedido_em; HOJE(); "DIA")

Example with values#

Input: call with no arguments (today's date, America/Sao_Paulo time zone).

code
HOJE()  →  2025-03-15

Expected result: 2025-03-15

NOT deterministic — changes every day; here we fix 2025-03-15 just to illustrate.

Business example#

Time analysis — order age, accrual month/year, accounting close.

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links