topic Join Date and Char in QlikView https://community.qlik.com/t5/QlikView/Join-Date-and-Char/m-p/189990#M52657 <HTML><HEAD></HEAD><BODY><P>Yes. You have to have a similar datatypes to do joins between tables. The char would be most likely interpreted as a text value and the date as a dual value with both text and number. Your best option would be to change the datatype of the char value in the following way.</P><P>...<BR />date#(trim(charDateField),'YYYYMMDD') as charDateField,<BR />...</P><P>The trim is just to make sure there is no whitespace character hiding in the column.</P><P>Regards.</P></BODY></HTML> Tue, 16 Nov 2010 21:35:47 GMT pover 2010-11-16T21:35:47Z Join Date and Char https://community.qlik.com/t5/QlikView/Join-Date-and-Char/m-p/189989#M52656 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I want to know we need to have similar datatypes for joining at script level in Qlikview?</P><P>I have a char to be joined with a date (Both YYYYMMDD) format.</P><P>Thanks in advance!!</P></BODY></HTML> Tue, 16 Nov 2010 19:54:25 GMT https://community.qlik.com/t5/QlikView/Join-Date-and-Char/m-p/189989#M52656 parpatra 2010-11-16T19:54:25Z Join Date and Char https://community.qlik.com/t5/QlikView/Join-Date-and-Char/m-p/189990#M52657 <HTML><HEAD></HEAD><BODY><P>Yes. You have to have a similar datatypes to do joins between tables. The char would be most likely interpreted as a text value and the date as a dual value with both text and number. Your best option would be to change the datatype of the char value in the following way.</P><P>...<BR />date#(trim(charDateField),'YYYYMMDD') as charDateField,<BR />...</P><P>The trim is just to make sure there is no whitespace character hiding in the column.</P><P>Regards.</P></BODY></HTML> Tue, 16 Nov 2010 21:35:47 GMT https://community.qlik.com/t5/QlikView/Join-Date-and-Char/m-p/189990#M52657 pover 2010-11-16T21:35:47Z