Mapping Dates in Qlickview

[#1]

My Database has Date format as 13-FEB-01 12.00.00.000000000 AM...I am trying to load the data in Qlikview and it gets failed..please let me know how can I fetch data into qlikview.

[hic]

Timestamp#(Date,'DD-MMM-YY hh.mm.ss.fff tt') as Date

[#3]

Hi Henric, Thanks for reply..but its not helping me..still not able to fetch the data.

[rwunderlich]

Please describe the problem you are seeing. Are you getting an error message? Null values?

It would be helpful if you could post the lines from the Document Log for the load statement in question.

-Rob

[#5]

Hi,

Try this :

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

or

Date(Timestamp#( DateField, 'DD/MMM/YY hh:mm:ss'), 'DD-MMM-YYYY')

as CreatedDate

Regards

[Sokkorn]

Hi Vikas,

Check my suggestion in this post http://community.qlik.com/message/226755#226755

Regards,

Sokkorn

[#7]

Hi Rob, I am getting null values when I am putting this in Qlikview. Actually I am not able to see the the Created_Date field after reloading the data in Qlikview.SET TimeFormat ='hh.mm.ss.fff tt';
SET DateFormat ='DD-MMM-YY';
SET TimestampFormat='DD-MMM-YY hh:mm:ss[.fff] TT';
SET MonthNames='JAN;FEB;MAR;APR;MAY;JUN;JUL;AUG;SEP;OCT;NOV;DEC';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

OLEDB CONNECT TO LOAD "CREATED_DATE";
SQL SELECT "CREATED_DATE" FROM Table_Name;

HI Sokkorn,

Sorry its still not working.

Regards,

Vikas

[rwunderlich]

Try running the script without the LOAD. Just use the SQL SELECT to see the raw values you get from the database.

-Rob