Last updated: August 29, 2026.
The DateSerial function constructs a Date value from numeric year, month, and day parts.
Syntax
DateSerial(year, month, day)| Argument | Description |
|---|---|
year | Required year number |
month | Required month number |
values outside 1–12 roll into adjacent years | undefined |
day | Required day number |
values outside the current month roll forward or backward | undefined |
Examples
DateSerial(2026, 8, 26) ' August 26, 2026
DateSerial(2026, 9, 0) ' Last day of August
RenewalDate: DateSerial(Year([StartDate]) + 1, Month([StartDate]), Day([StartDate]))Use four-digit years. DateSerial intentionally normalizes out-of-range parts, which is useful for date arithmetic but can hide invalid input if values are not validated.
See Microsoft’s Access function reference for related expression functions.
Moving an Access application to the web? See how PHPRunner can replace Access forms, queries, and reports.
Use DateSerial in complete queries
These examples apply DateSerial to common filtering, grouping, age, and crosstab tasks.
3 thoughts on “Access DateSerial Function”