Skip to content

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

AGORA

On this page (10)

Current date and time.

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

Aliases#

Canonical name: AGORA. Accepted aliases (case-insensitive): now.

Syntax#

code
AGORA()

All arguments are expressions.

Returns#

Date and time.

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: NOW
  • Compatibility: DIFFERS from DAX — different semantics, watch out
  • Note: Uses the America/Sao_Paulo time zone; DAX NOW uses the service's time zone (typically UTC).

Examples#

code
AGORA()

Example with values#

Input: call with no arguments (current date and time, America/Sao_Paulo time zone).

code
AGORA()  →  2025-03-15 14:30

Expected result: 2025-03-15 14:30

NOT deterministic — changes every instant; here we fix 2025-03-15 14:30 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