bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access DateSerial() Function

Concept visual

MS Access DateSerial() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

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).

Syntax

DateSerial(

year, month, day )

Parameter Values

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)

Technical Details

Works in:

From Access 2000

More Examples

Example

Return a date from it's parts:

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

Previous

❮ MS Access Functions

Next

Previous

MS Access DatePart() Function

Next

MS Access DateValue() Function