Skip to content
Infoveave Help

YEAR

The YEAR function in Infoveave is used to extract the year from a given date.

Applicable to

Calculated Columns

Return Value

The YEAR function returns the year value as an integer for a given date.

Remark

  • The function is useful for extracting the year from dates for analysis, such as grouping data by year, performing year-over-year comparisons, and filtering data by year.
  • The YEAR function returns “Invalid Date” on null or blank values.

Syntax

WEEKDAY(<expression>)


YEAR in Calculated Columns

Instructions

Write the YEAR function. For instance

YEAR(<expression>)
  1. Replace <expression> with the start period. You can also call in @StartDate and @EndDate function.
  2. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Suppose you want to create a column that returns the year value based on the column SALES DATE, you can use the YEAR function as follows

YEAR(DATEVALUE(VALUE([Sales Date])))