Date - script and chart function

The date function formats the expression as a date according to the given format-code string.

Syntax:  

Date(expression [ , format-code ])

 

Another way to describe it, is to look at it as a number to string conversion. The function takes the numeric value of the expression and generates a string representing the date according to the format code. The function returns a dual value with both the string and the number.

Arguments:  

Examples and results:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Date format	YY-MM-DD	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	8/6/97
	Number:	35648	35648
Date( A, 'DD.MM.YY' ) 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