topic Re: date format in QlikView

date format

london1980 — Fri, 30 Oct 2015 14:26:29 GMT

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 — Fri, 30 Oct 2015 15:52:44 GMT

May be try this in load script:

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

handry_orozco — Fri, 30 Oct 2015 15:59:12 GMT

Try,

from database:

Select Cast(Field1 AS Date) as Field1

From Table1;

QlikView:

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

Joaquin_Lazaro — Fri, 30 Oct 2015 15:59:36 GMT

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 — Fri, 30 Oct 2015 16:13:26 GMT

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

Load

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

From Table...