Date - script and chart function

Date() formats an expression as a date using the format set in the system variables in the data load script, or the operating system, or a format string, if supplied.

Syntax:  

Date(number[, format])

Return data type: dual

Arguments:  

Examples and results:

The examples below assume the following default settings:

• Date setting 1: YY-MM-DD
• Date setting 2: M/D/YY

Example	Results	Setting 1	Setting 2
Date( A ) where A=35648	String:	97-08-06	8/6/97
	Number:	35648	35648
Date( A, 'YY.MM.DD' ) where A=35648	String:	97.08.06	97.08.06
	Number:	35648	35648
Date( A, 'DD.MM.YYYY' ) where A=35648.375	String:	06.08.1997	06.08.1997
	Number:	35648.375	35648.375
Date( A, 'YY.MM.DD' ) where A=8/6/97	String:	NULL (nothing)	97.08.06
	Number:	NULL	35648