Skip to content

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

EDATE

On this page (10)

Same date N months ahead (or back).

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

Aliases#

Canonical name: EDATE. Accepted aliases (case-insensitive): datames.

Syntax#

code
EDATE(expr; arg2)

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: EDATE
  • Compatibility: Compatible with DAX
  • Note: Same date N months ahead/back.

Examples#

code
EDATE(pedido_em; -1)

Example with values#

Input: 2025-03-15 minus 1 month.

code
EDATE(DATA(2025;3;15); -1)  →  2025-02-15

Expected result: 2025-02-15

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