dates imported as text - how to convert to date???

[#1]

Hi,

I´m relatively new to Qlikview and create my reports more or less like try-and-error

Now I ran into a problem with date imported from SAP-BW-File.

dates are somehow imported to Qlik in textformat not as date.

therefore I can´t calculate with simple if-then-else formular.

I´ve already tried tipps from other posts like import as date() but it does not work for me.

could someone give me a hand on this, please?

I´ve created a basic report for this (attached)

Many Thanks,

jens

[spividori · Accepted solution]

Hi.

Try:

LOAD No.,

    date(RDD) as RDD,

    date([Goods issue]) as [Goods issue],

    PC

FROM Dates.xls (biff, embedded labels, table is Detailreport$);

Regards.

[#3]

Hi,

try

LOAD No.,

          date#(RDD,'DD.MM.YYY') as RDD,

          date#([Goods issue],'DD.MM.YYY') as [Goods issue],

          PC

FROM Dates.xls (biff, embedded labels, table is Detailreport$);

[#4]

Hi,

your excel file has preceeding ' in your dates which is why the date function is not working for you when you use it,

please see attached it works fine is you remove these

thanks

Joe

[#5]

Many thanks to you all for your support on this.

I don´t get the point why it does work with the Date () function  now - but it does.

I´m quite sure that I´ve done it before in the same way - but anyway -> it´s solved.

Again many thanks.

Jens

[#6]

Many thanks to you all for your support on this.

I don´t get the point why it does work with the Date () function  now - but it does.

I´m quite sure that I´ve done it before in the same way - but anyway -> it´s solved.

Again many thanks.

Jens

[#7]

check your excel file and have a look at the dates

it was coming through as '01.09.2011

instead of 01.09.2011

that ' was causing the date function to struggle it seems

thanks

Joe