topic Re: Concatenate Date + String in QlikView https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908559#M315488 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 21 Jul 2015 15:27:42 GMT 2015-07-21T15:27:42Z Concatenate Date + String https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908555#M315484 <HTML><HEAD></HEAD><BODY><P>Hi there - I have three fields I am working with:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 239px; height: 65px;" width="237"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Example Date</STRONG></TH></TR><TR><TD style="padding: 2px;">Date</TD><TD style="padding: 2px;">2/4/2014</TD></TR><TR><TD style="padding: 2px;">Week Type</TD><TD style="padding: 2px;">Off</TD></TR><TR><TD style="padding: 2px;">Week Number</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>I'd like to show all three together like this: "Feb 4-Off-1"</P><P></P><P>When I use <STRONG>[Date]&amp;'-'&amp;[Week Type]&amp;'-'&amp;[Week Number]</STRONG> I get "41674-Off-1"</P><P></P><P>How do I keep or change the date formula to display properly?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 21 Jul 2015 15:16:10 GMT https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908555#M315484 2015-07-21T15:16:10Z Re: Concatenate Date + String https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908556#M315485 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Date(Date,'MMM D')&amp;'-'&amp;[Week Type]&amp;'-'&amp;[Week Number]</STRONG></P></BODY></HTML> Tue, 21 Jul 2015 15:24:17 GMT https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908556#M315485 MarcoWedel 2015-07-21T15:24:17Z Re: Concatenate Date + String https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908557#M315486 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Date(Date, 'MMM D')&amp;'-'&amp;[Week Type]&amp;'-'&amp;[Week Number]</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG> </STRONG></SPAN></P></BODY></HTML> Tue, 21 Jul 2015 15:24:41 GMT https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908557#M315486 sunny_talwar 2015-07-21T15:24:41Z Re: Concatenate Date + String https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908558#M315487 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hope this helps<BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Month(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Date])<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&amp;'&nbsp; '&amp; <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Day(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Date])</STRONG></STRONG> </STRONG></STRONG> &amp;'-'&amp;[Week Type]&amp;'-'&amp;[Week Number]</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> </SPAN></P></BODY></HTML> Tue, 21 Jul 2015 15:25:52 GMT https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908558#M315487 Anonymous 2015-07-21T15:25:52Z Re: Concatenate Date + String https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908559#M315488 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 21 Jul 2015 15:27:42 GMT https://community.qlik.com/t5/QlikView/Concatenate-Date-String/m-p/908559#M315488 2015-07-21T15:27:42Z