Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I found a solution to this issue in the below link
Thanks for the help
did you try
date#(date,'DD.MM.YYYY')
Hi!
You are looking for which database? Perhaps the ideal would be to change the format in the language of the bank.
Rebeca
In your script, is your date format set to match?
SET DateFormat='MM.DD.YYYY';
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
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
HI ,
Try the below code
date#(Date,'DD.MM.YYYY') as test,
Please reply me for the same.
//Yusuf
That still doesnt work unfortunately
I still keep getting a variation of this string whenever I convert the date - 7978785879
Hi,
In qlikview it can be handled just need more info about your load .
Can you please attach the sample file .
//Yusuf
Try this:
Date(Left(Field, 2) & Mid(Field, 4, 2) & Right(Field, 4))