Last updated: August 26, 2026.
The Day function returns an integer from 1 through 31 representing the day of the month.
Syntax
Day(date)| Argument | Description |
|---|---|
date | Date expression |
Examples
Day(#8/26/2026#) ' 26
InvoiceDay: Day([InvoiceDate])
TodayDay: Day(Date())A Null date returns Null. Day alone is not a unique calendar date; keep the year and month when grouping records.
See Microsoft’s Access function reference for related expression functions.
