Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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
Highlighted
Partner
Partner

did you try

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

Highlighted
Not applicable

Hi!

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

Rebeca

Highlighted
Master II
Master II

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

     SET DateFormat='MM.DD.YYYY';

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted
Not applicable

HI ,

        Try the below code

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

Please reply me for the  same.

//Yusuf

Highlighted
Not applicable

That still doesnt work unfortunately

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

Highlighted
Not applicable

Hi,

   

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

Can you please attach the sample file .

//Yusuf

Highlighted
Creator III
Creator III

Try this:

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