DATE

The following section describes the syntax and usage of the DATE function in ActivityInfo.

Description

The DATE function is used to convert a set of Year, Month and Day values into a Date.

Syntax

DATE(year, month,day)

Argument Required Description
year Yes The full, numeric year value according to the Gregorian calendar.
month Yes The numeric month value according to the Gregorian calendar.
day Yes The numeric day value according to the Gregorian calendar.

Result

The Date value of the given arguments.

Example

We will be using the DATE function to calculate the date from a set of three columns giving the day, month and year values.

Arguments

We will be using three Quantity fields:

  • "Year" (with code "YEAR")
  • "Month" (with code "MONTH")
  • "Day" (with code "DAY")

Formula

DATE(YEAR,MONTH,DAY)

Results