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:

Argument	Description
number	The number to be formatted.
format	String describing the format of the resulting string. If no format string is supplied, the date format set in the operating system is used.

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
Date( A ) where A=35648	Number:	35648	35648
Date( A, 'YY.MM.DD' ) where A=35648	String:	97.08.06	97.08.06
Date( A, 'YY.MM.DD' ) where A=35648	Number:	35648	35648
Date( A, 'DD.MM.YYYY' ) where A=35648.375	String:	06.08.1997	06.08.1997
Date( A, 'DD.MM.YYYY' ) where A=35648.375	Number:	35648.375	35648.375
Date( A, 'YY.MM.DD' ) where A=8/6/97	String:	NULL (nothing)	97.08.06
Date( A, 'YY.MM.DD' ) where A=8/6/97	Number:	NULL	35648

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here