Won't load Dates correctly from DB2 Database...

[#1]

Hello,

So, I am loading data into QlikView from a DB2 database, and one field within the Database is a DATE field. However, when I load the data into QlikView, it does not recognise the date correctly.

Does anyone know how to fix this?

Thanks

[rbecher]

Hi Beth,

what is your default QlikView date format?

SET DateFormat=...?

- Ralf

[#3]

Hi, it is set to the Default 'DD/MM/YYYY'

[rbecher]

What do you get with:

LOAD
Text(PROCESS_DATE) as "PROCESS_DATE";

SQL SELECT PROCESS_DATE FROM TABLE;

[#5]

I get:

41311

41313

41525

[jagan]

HI,

Try this

LOAD
Date(Num(Text(PROCESS_DATE))) as "PROCESS_DATE";

SQL SELECT PROCESS_DATE FROM TABLE;

Regards,

Jagan.

[#7]

Once again nothing appears in the drop down

[jagan]

Hi,

Can you attach the sample file.

Regards,

jagan.

[#9 · Accepted solution]

Have solved this. It seems QlikView can't read date fields but can read TimeStamp fields.