The DateTimeToDate function is a built-in function that converts DateTime dt to a date value, dropping the time component.

Input parameters

dt: DateTime Type

Output parameters

Date Type

Examples

Usage

Result

DateTimeToDate( #2013-11-30 22:20:30# )

#2013-11-30#

Remarks

You should check the limits of the Date Time data type.

See Also

Available Conversion Functions to Date | Available Built-in Functions