Skip to content
Infoveave Help

DATE

The DATE function in Infoveave creates a date based on the specified year, month, and day components.

Applicable to

Calculated Columns

Return Value

The function returns a date value in the format YYYY-MM-DD based on the specified year, month, and day.

Remark

  • The DATE function does not perform any validation on the input values.
  • The YEAR is recommended to have an argument of four digits.
  • The MONTH and DAY are recommended to have arguments of two digits.
  • Decimal values will be rounded to the closest value.
  • Valid values for MONTH are 01-12. If MONTH is a number from 01 to 12, then it represents a month of the year. If you enter an integer larger than 12, the date is calculated by adding the value of month to the year.
  • Valid values for DAY are 01-31. If DAY is a number from 01 to 31, then it represents the day of the year. If you enter an integer larger than 31, the date is calculated by adding the value of day to the month and year.

Syntax

DATE(year, month, date)

DATE in Calculated Columns

ExpressionDescription
YearThe substring you want to substitute.
MonthThe substring that will substitute your search.
DayThe occurrence of substring you want to substitute.

Steps to Use DATE

  1. Write the DATE function. For instance DATE(year, month, date)
  2. Replace year with the year value required.
  3. Replace month with the month value required.
  4. Replace day with the day value required.
  5. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Suppose you want to create a date for January 21, 2024. You can use the DATE function as follows

DATE(2024, 01, 21)