topic Mapping Dates in Qlickview in QlikView

Mapping Dates in Qlickview

Fri, 08 Jun 2012 21:30:52 GMT

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.

Mapping Dates in Qlickview

hic — Fri, 08 Jun 2012 21:51:09 GMT

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

Re: Mapping Dates in Qlickview

Fri, 08 Jun 2012 22:06:35 GMT

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

Mapping Dates in Qlickview

rwunderlich — Fri, 08 Jun 2012 23:28:31 GMT

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

Re: Mapping Dates in Qlickview

Fri, 08 Jun 2012 23:40:39 GMT

Hi,

Try this :

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

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

as CreatedDate

Regards

Re: Mapping Dates in Qlickview

Sokkorn — Sat, 09 Jun 2012 02:20:08 GMT

Hi Vikas,

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

Regards,

Sokkorn

Re: Mapping Dates in Qlickview

Mon, 11 Jun 2012 15:45:14 GMT

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

Re: Mapping Dates in Qlickview

rwunderlich — Tue, 12 Jun 2012 04:22:54 GMT

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

-Rob