Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following date format in my SQL SERVER = DD/MM/YYYY => Brazil Date
When I import this into Qlikview it comes across as a string like this = 20020627
When i change the format in "properties list" switch to "Data" DD/MM/YYYY The qlik view Show = 12/08/56714
Any ideas on how to change this a date in Qlikview?
Thanks
Marcos
Error in expression:
Date# takes 1-2 parameters
Load *, Date(Date#(TJ_DTMPINI,'YYYYMMDD','DD/MM/YYYY') as NewDate
Load
F1,
F2,
Date(Date#(Your_Date,'YYYYMMDD','DD/MM/YYYY'),
F4;
sql select * from table;
Regards
ASHFAQ
Ashfaq,
I'm new in qlick view, could you show me how to make, below is my script.
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=EBRASIL_PROD;Data Source=192.168.0.4;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ULTRA-MARCOS;Use Encryption for Data=False;Tag with column collation when possible=False];
SQL SELECT *
FROM "EBRASIL_PROD".dbo.STJ010;
The field i want to convert is "TJ_DTMPINI"
Thanks
Just use
Load *,
Date(Date#(TJ_DTMPINI,'YYYYMMDD'),'DD/MM/YYYY') as NewDate;
SQL SELECT * FROM "EBRASIL_PROD".dbo.STJ010;
instead of your current SELECT statement.
The reason why you have this problem is that your date date isn't stored as a date type in the SQL SERVER. It is probably a VARCHAR or an INTEGER. Had it been a date type, it would have worked automatically.
HIC
Error in expression:
Date# takes 1-2 parameters
Load *, Date(Date#(TJ_DTMPINI,'YYYYMMDD','DD/MM/YYYY') as NewDate
You're right. It is corrected now. I just added the missing bracket.
HIC
Sorry, you do not understand, this was the error message that QLIK returned, not what I wrote. How is the correct expression?
Thanks
Load *,
Date(Date#(TJ_DTMPINI,'YYYYMMDD'),'DD/MM/YYYY') as NewDate;
SQL SELECT * FROM "EBRASIL_PROD".dbo.STJ010;
HIC
Allright, almost there heheh. I have more two 'date' fields, can't repeat the command. How i proceed.
Thanks.