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
