topic Re: Covert Day Number into Date in QlikView https://community.qlik.com/t5/QlikView/Covert-Day-Number-into-Date/m-p/78523#M12942 <HTML><HEAD></HEAD><BODY><P>‌Try this</P><P></P><P>Date(Date#(Day_Num&amp;’-‘&amp;Month_Year, ‘D-MMM-YYYY’), ‘MM/DD/YYYY) as Date</P></BODY></HTML> Sun, 10 Jun 2018 00:35:19 GMT sunny_talwar 2018-06-10T00:35:19Z Covert Day Number into Date https://community.qlik.com/t5/QlikView/Covert-Day-Number-into-Date/m-p/78522#M12941 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have day column and month with year but I need date.</P><P></P><P>For Example,</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Day_Num</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month_Year</TH></TR><TR><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">JAN-2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;">JAN-2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">3</TD><TD style="padding: 2px; text-align: center;">JAN-2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;">JAN-207</TD></TR><TR><TD style="padding: 2px; text-align: center;">5</TD><TD style="padding: 2px; text-align: center;">JAN-2017</TD></TR></TBODY></TABLE><P></P><P><STRONG>Expected Results:</STRONG></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Day_Num</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month_Year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date</TH></TR><TR><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">JAN-2017</TD><TD style="padding: 2px; text-align: center;">01/01/2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">JAN-2017</SPAN></TD><TD style="padding: 2px; text-align: center;">01/02/2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">3</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">JAN-2017</SPAN></TD><TD style="padding: 2px; text-align: center;">01/03/2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">JAN-2017</SPAN></TD><TD style="padding: 2px; text-align: center;">01/04/2017</TD></TR><TR><TD style="padding: 2px; text-align: center;">5</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">JAN-2017</SPAN></TD><TD style="padding: 2px; text-align: center;">01/05/2017</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Lawrance A</P></BODY></HTML> Sat, 09 Jun 2018 23:13:16 GMT https://community.qlik.com/t5/QlikView/Covert-Day-Number-into-Date/m-p/78522#M12941 lawrance 2018-06-09T23:13:16Z Re: Covert Day Number into Date https://community.qlik.com/t5/QlikView/Covert-Day-Number-into-Date/m-p/78523#M12942 <HTML><HEAD></HEAD><BODY><P>‌Try this</P><P></P><P>Date(Date#(Day_Num&amp;’-‘&amp;Month_Year, ‘D-MMM-YYYY’), ‘MM/DD/YYYY) as Date</P></BODY></HTML> Sun, 10 Jun 2018 00:35:19 GMT https://community.qlik.com/t5/QlikView/Covert-Day-Number-into-Date/m-p/78523#M12942 sunny_talwar 2018-06-10T00:35:19Z