date format

[london1980]

Hello!

My database generating dates in this format

03-Aug-15

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

cheers..

[sunny_talwar · Accepted solution]

May be try this in load script:

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

[handry_orozco]

Try,

from database:

Select Cast(Field1 AS Date) as Field1

     From Table1;

Or

QlikView:

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

[JoaquinLazaro]

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

[MK_QSL]

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

Load

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

From Table...