DATE()

The DATE() operator converts an expression to a DATE value.

Syntax

DATE [(expr)]
  1. expr is the expression to be converted to a date.

Usage

DATE() converts a character string, an integer or datetime expression to a DATE value.

When expr is a character string expression, it must properly formatted by following the datetime format settings like DBDATE.

If expr is an integer expression, it is used as the number of days since December 31, 1899.

If you supply no operand, it returns a character representation of the current date in the format "weekday month day year".

Example

MAIN
  DISPLAY DATE ( 34000 )
  DISPLAY DATE ( "12/04/1978" )
  DISPLAY DATE ( CURRENT )
END MAIN