From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Function: DateValue()

Purpose: The DateValue() function returns a date variant containing the date corresponding to the input.

Usage: DateValue(date_expression)

The input date_expression is usually a string value, but can be any expression that evaluates to a date in the range January 1, 100 through December 31, 9999.

Returns: Date variant corresponding to date_expression.

Examples and Special Cases

All of the following return a date variant set to 2/1/2006:
DateValue(“February 1, 2006”)
DateValue(“2/1/2006”)
DateValue(DateValue(“1/31/2006”)+1)