Date# - script and chart function

Date# evaluates an expression as a date in the format specified in the second argument, if supplied.

Syntax:

Date#(text[, format])

Return data type: dual

Arguments:

Arguments
Argument	Description
text	The text string to be evaluated.
format	String describing the format of the text string to be evaluated. If omitted, the date format set in the system variables in the data load script, or the operating system is used. Descriptions for number and time formats

The following example uses the date format M/D/YYYY. The date format is specified in the SET DateFormat statement at the top of the data load script.

Add this example script to your app and run it.

Load *,

Num(Date#(StringDate)) as Date;

LOAD * INLINE [

StringDate

8/7/97

8/6/1997

]

If you create a table with StringDate and Date as dimensions, the results are as follows:

Results
StringDate	Date
8/7/97	35649
8/6/1997	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 – let us know how we can improve!