Skip to main content
DATE

Creates a date based on the provided year, month, and day values

Updated over a year ago

Description

The DATE() function generates a date by combining the specified year, month, and day values. This is useful for creating date-based records, scheduling events, or working with date-related data.

Syntax

DATE(year, month, day)

Output

date

Variables

  1. year: The numeric value representing the year (e.g., 2023).

  2. month: The numeric value representing the month (1 for January, 2 for February, and so on).

  3. day: The numeric value representing the day of the month.

Example

Date (`Year`, `Month`, `Day`)

Event

Year

Month

Day

DATE

Birthday Party

2023

9

15

9/15/23

Anniversary

2024

4

10

4/10/24

Conference

2023

11

20

11/20/23

Did this answer your question?