DateSerial

Construct a date using its individual components.

SELECT DateSerial(2017, 4, 20);

Definition and Usage

The DateSerial() function generates a date using specified parts such as year, month, and day values.

DateSerial(year, month, day)

Parameter	Description
year	Mandatory. Specifies a year using four digits.
month	Mandatory. Specifies a month, ranging from 1 to 12.
day	Mandatory. Specifies a day, ranging from 1 to 31.

WORKS IN

From Access 2000

Construct a complete date using its individual components.

SELECT DateSerial(2017–10, 4–1, 20–5);