Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

london1980
New Contributor

date format

Hello!

My database generating dates in this format

03-Aug-15

Anyone knows how to turn this into standard sortable date format?

cheers..

1 Solution

Accepted Solutions

Re: date format

May be try this in load script:

Date(Date#(DateField, 'DD-MMM-YY')) as DateField,

4 Replies

Re: date format

May be try this in load script:

Date(Date#(DateField, 'DD-MMM-YY')) as DateField,

handry_orozco
New Contributor III

Re: date format

Try,

from database:

Select Cast(Field1 AS Date) as Field1

     From Table1;

Or

QlikView:

Date(Field1,'DD/MM/YYYY') AS Field1

joaquinlr
Valued Contributor II

Re: date format

Hi

At the begining of the script you have this senteces

SET TimeFormat='h:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';

Use them combined with functions Date() and Date#() to get your desired date format

Hope it helps you

Joaquín

Re: date format

If you use below while loading, you can sort according to numer


Load

     Date#(YourDateField,'DD-MMM-YY') as YourDateField

From Table...

Community Browser