The DateToText function is a built-in function that converts Date d to a Text value in the format "yyyy-mm-dd".

This function is available within the expression editor and the query condition editor.

Input parameters

Output parameters

Examples

Usage

Result

DateToText (2001-09-14)

"2001-09-14"

Remarks

You should check the limits of the Date data type.

See Also

Available Data Type Conversion Functions | Available Built-in Functions