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!