MS Access DateSerial() Function

Return a date from it's parts:

SELECT DateSerial(2017, 4, 20);

Definition and Usage

The DateSerial() function returns a date from the specified parts (year, month, and day values).

DateSerial(year, month, day)

Parameter	Description
year	Required. Specifies a year (4 digits)
month	Required. Specifies a month (from 1 to 12)
day	Required. Specifies a day (from 1 to 31)

Works in:	From Access 2000

Return a date from it's parts:

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