Skip to main content

Date# - script and chart function

Date# converts a text string to a numerical date by applying the provided date format pattern, or if omitted by the default date format pattern.


Date#(text[, format])

Return data type: dual


Date# arguments
Argument Description

The text string to be evaluated.

format String describing how the resulting date string is to be formatted. If omitted, the date format set in the operating system is used.


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;







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

Example 1 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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: