https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161602#M35420 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>in expression edit, i want to concatenate date dim such as dd/mm/yyyy</P><P>what's about this code?</P><P>I use qlikview expression but it displays error</P><P></P><P>Yours faithfully</P></BODY></HTML> Mon, 16 Aug 2010 10:12:09 GMT 2010-08-16T10:12:09Z https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161602#M35420 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>in expression edit, i want to concatenate date dim such as dd/mm/yyyy</P><P>what's about this code?</P><P>I use qlikview expression but it displays error</P><P></P><P>Yours faithfully</P></BODY></HTML> Mon, 16 Aug 2010 10:12:09 GMT https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161602#M35420 2010-08-16T10:12:09Z https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161603#M35421 <HTML><HEAD></HEAD><BODY><P>if you have a field with a date format, you have just to write :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">date(MyDateField,'DD/MM/YYYY')</PRE></BLOCKQUOTE><BR /><BR /> <P>if it's a date in text format :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">date#(MyDateField,'DD/MM/YYYY')</PRE></BLOCKQUOTE><BR /><BR /> <P>if you have three fields (year, month and day) :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">makedate(YearField,MonthField,DayField)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 16 Aug 2010 10:15:22 GMT https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161603#M35421 martin59 2010-08-16T10:15:22Z https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161604#M35422 <HTML><HEAD></HEAD><BODY><P>date(Makedate(Add Parameter Here))</P></BODY></HTML> Mon, 16 Aug 2010 10:17:14 GMT https://community.qlik.com/t5/QlikView/Date-concatenation/m-p/161604#M35422 suniljain 2010-08-16T10:17:14Z