Last updated: August 26, 2026.
The DateValue function converts a recognizable date expression to a Date value with the time portion removed.
Syntax
DateValue(date)| Argument | Description |
|---|---|
date | Date or text expression recognized using the current regional settings |
Examples
DateValue("August 26, 2026")
OrderDay: DateValue([OrderTimestamp])
TodayOnly: DateValue(Now())Text interpretation depends on regional settings. For stored data and imports, prefer unambiguous date values or build the date with DateSerial.
See Microsoft’s Access function reference for related expression functions.
