1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. DATE

Use the DATE function to combine values, representing the year, month, and day, to form a date.

The format used to display the date depends on your OS/browser settings. For example, the U.S. date format displays the month before the day (mm/dd/yyyy): 12/25/2018.

Syntax

DATE(year, month, day)

The DATE function has the following arguments:

Argument Data type Description
year (required)

Number

A four-digit number representing the year.

month (required)

Number

A number (between 1 and 12, inclusive) representing the month.

day (required)

Number

A number (between 1 and 31, inclusive) representing the day.

Constraints

The DATE function has the following constraints:

  • The month must be a number between 1 and 12, inclusive.
  • The day must be a number between 1 and 31, inclusive.
  • The values must represent a valid date (01/01/1900 —12/31/2399).

If any of these conditions are not satisfied, the result is blank.

Examples

The following table shows some example formulas using the DATE function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result (U.S. format mm/dd/yyyy)
DATE(2018, 12, 25)

This example shows how you can enter values directly into your formula.

12/25/2018

DATE(Previous Year, Start Month, 3)

This example shows how you can reference line items or list properties in your formula.

These values are taken from the configuration on the Time settings.

03/01/2017

DATE(2018.3, 2.65, 8.4)

This example shows how the DATE function will round to the nearest whole number.

This is useful if you have generated inputs using expressions that might not return whole numbers.

03/08/2018

Excel equivalent