Converting date format

[#1]

Hi,

I have the following date format in my system = 01.01.2013

When I import this into Qlikview it comes across as a string like this = 79869598

Any ideas on how to change this a date in Qlikview?

I've used functions date and #date...

Many Thanks

[PhilippeMotillon]

did you try

date#(date,'DD.MM.YYYY')

[#3]

Hi!

You are looking for which database? Perhaps the ideal would be to change the format in the language of the bank.

Rebeca

[m_woolf]

In your script, is your date format set to match?

     SET DateFormat='MM.DD.YYYY';

[#5]

When I use this code

date#(date(Date),'DD.MM.YYYY') as test,

Then date format comes out as this... 24.11.220904

I have also set the DateFormat to 'MM.DD.YYYY'

Any ideas?

Thanks

[#6]

Im pulling the info from an SAP system (SQL)

I've extracted dates from on this DB before and havent had any issues... this seems very strange

[#7]

HI ,

        Try the below code

date#(Date,'DD.MM.YYYY') as test,

Please reply me for the  same.

//Yusuf

[#8]

That still doesnt work unfortunately

I still keep getting a variation of this string whenever I convert the date - 7978785879

[#9]

Hi,

In qlikview it can be handled just need more info about your load .

Can you please attach the sample file .

//Yusuf

[calvindk]

Try this:

Date(Left(Field, 2) & Mid(Field, 4, 2) & Right(Field, 4))