Description
Creates a Date from the given year, month a day.
Syntax
DATE(Year, Month, Day)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Year (required) | Integer | Any Dimensions | Year of the date. |
| Month (required) | Integer | No Dimension or Dimensions of argument Year | Month of the date. |
| Day (required) | Integer | No Dimension or Dimensions of argument Year | Day of the date. |
Returns
| Type | Dimensions |
|---|---|
| Text | Dimensions of argument Year |
Examples
| Formula | Result | Description |
|---|---|---|
|
| 02/12/2020 00:00:00 +00:00 | It returns a date in UTC time format with Text data type.
Use with Locale date time formatting to manage how it is displayed. |
Note
How to convert date to text
To convert a date to text format, use the DATE() function together with the YEAR(), MONTH() and DAY() functions. Select Locale date time formatting to manage how the date is displayed.
For example:
DATE(YEAR(your_date), MONTH(your_date), DAY(your_date))
Where your_date refers to an object of Date data type in a List or Metric.
See also
Excel: DATE
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!