Date# - script and chart function

Date# evaluates an expression as a date in the format set in the operating system, by default, or in the format specified in the second argument, if supplied.

Syntax:  

Date#(text[, format])

Return data type: dual

Arguments:   

Examples and results:

The examples below assume the two following operating system settings:

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

Example	Results	Setting 1	Setting 2
Date#( A ) where A='8/6/97'	String:	8/6/97	8/6/97
	Number:	-	35648
Date#( A, 'YYYY.MM.DD' ) where A='1997.08.06'	String:	1997.08.06	1997.08.06
	Number:	35648	35648