Last updated: August 26, 2026.
The Month function returns an integer from 1 through 12 identifying the month of a date.
Syntax
Month(date)| Argument | Description |
|---|---|
date | Date expression |
Examples
Month(#8/26/2026#) ' 8
OrderMonth: Month([OrderDate])
CurrentMonth: Month(Date())A Null argument returns Null. Use MonthName when a localized display label is needed.
See Microsoft’s Access function reference for related expression functions.
