Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting date format

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

1 Solution

Accepted Solutions
Not applicable
Author

I found a solution to this issue in the below link

Thanks for the help

http://community.qlik.com/thread/15779

View solution in original post

23 Replies
PhilippeMotillon
Partner - Creator
Partner - Creator

did you try

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

Not applicable
Author

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
Master II
Master II

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

     SET DateFormat='MM.DD.YYYY';

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

HI ,

        Try the below code

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

Please reply me for the  same.

//Yusuf

Not applicable
Author

That still doesnt work unfortunately

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

Not applicable
Author

Hi,

   

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

Can you please attach the sample file .

//Yusuf

calvindk
Creator III
Creator III

Try this:

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