DATE

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

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)

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

Table

Event	Year	Month	Day
Birthday Party	2023	9	15
Anniversary	2024	4	10
Conference	2023	11	20

Function

DATE(`Year`, `Month`, `Day`)

Results

DATE (date)
2023-09-15
2024-04-10
2023-11-20