Discussion Board for collaboration related to QlikView App Development.
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...
I found a solution to this issue in the below link
Thanks for the help
View solution in original post
did you try
You are looking for which database? Perhaps the ideal would be to change the format in the language of the bank.
In your script, is your date format set to match?
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'
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
Try the below code
date#(Date,'DD.MM.YYYY') as test,
Please reply me for the same.
That still doesnt work unfortunately
I still keep getting a variation of this string whenever I convert the date - 7978785879
In qlikview it can be handled just need more info about your load .
Can you please attach the sample file .
Date(Left(Field, 2) & Mid(Field, 4, 2) & Right(Field, 4))