Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
My database generating dates in this format
03-Aug-15
Anyone knows how to turn this into standard sortable date format?
cheers..
May be try this in load script:
Date(Date#(DateField, 'DD-MMM-YY')) as DateField,
May be try this in load script:
Date(Date#(DateField, 'DD-MMM-YY')) as DateField,
Try,
from database:
Select Cast(Field1 AS Date) as Field1
From Table1;
Or
QlikView:
Date(Field1,'DD/MM/YYYY') AS Field1
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
If you use below while loading, you can sort according to numer
Load
Date#(YourDateField,'DD-MMM-YY') as YourDateField
From Table...