bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access DateSerial() Function

Example

SELECT DateSerial(2017, 4, 20);

Definition and Usage

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

Syntax

DateSerial(
year
,
month
,
day
)

Parameter Values

ParameterDescription
yearRequired. Specifies a year (4 digits)
monthRequired. Specifies a month (from 1 to 12)
dayRequired. Specifies a day (from 1 to 31)

Technical Details

Works in:From Access 2000

Previous

MS Access DatePart() Function

Next

MS Access DateValue() Function