Skip to content

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

DATA

On this page (10)

Builds the date from year; month; day.

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

Aliases#

Canonical name: DATA. Accepted aliases (case-insensitive): date.

Syntax#

code
DATA(expr; arg2; arg3)

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: DATE
  • Compatibility: Compatible with DAX
  • Note: Builds the date from year; month; day.

Examples#

code
DATA(2026; 7; 27)

Example with values#

Input: year 2026, month 7, day 27.

code
DATA(2026; 7; 27)  →  2026-07-27

Expected result: 2026-07-27

Business example#

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

Common errors#

DATA: … for a year/month/day that doesn't form a valid date.


← Back to the formula index

Related links