The DateToText function is a built-in function that converts Date d to a text value in the format specified in the environment configuration (by default, YYYY-MM-DD).

Input parameters

d: Date Type

Output parameters

Text Type

Examples

Usage

Result

DateToText( #2010-05-17# )

"2010-05-17"

DateToText( #2010-05-17 22:30:32# )

"2010-05-17"

Remarks

You should check the limits of the Date data type.

See Also

Available Conversion Functions to Text | Available Built-in Functions