topic Re: Day names in QlikView https://community.qlik.com/t5/QlikView/Day-names/m-p/709252#M255562 <HTML><HEAD></HEAD><BODY><P>try with</P><P>=WeekDay(Date#(Date,'MM/DD/YYYY'))</P><P>or with</P><P>=WeekDay(Date)</P></BODY></HTML> Thu, 03 Jul 2014 16:54:02 GMT maxgro 2014-07-03T16:54:02Z Day names https://community.qlik.com/t5/QlikView/Day-names/m-p/709251#M255561 <HTML><HEAD></HEAD><BODY><P>I am still new to QlikView and I am taking in values from an excel sheet and would like to exclude the values in a straight table that fall on a Saturday or Sunday. The values are being input into the excel sheet in the form of MM/DD/YYYY, and whenever I try the command:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">WeekDay</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 10pt;">I get Saturday, or more specifically 'Sat', every time, even though the second date refers to the column containing the dates. How can I achieve my desired result?</SPAN></P></BODY></HTML> Thu, 03 Jul 2014 16:10:42 GMT https://community.qlik.com/t5/QlikView/Day-names/m-p/709251#M255561 2014-07-03T16:10:42Z Re: Day names https://community.qlik.com/t5/QlikView/Day-names/m-p/709252#M255562 <HTML><HEAD></HEAD><BODY><P>try with</P><P>=WeekDay(Date#(Date,'MM/DD/YYYY'))</P><P>or with</P><P>=WeekDay(Date)</P></BODY></HTML> Thu, 03 Jul 2014 16:54:02 GMT https://community.qlik.com/t5/QlikView/Day-names/m-p/709252#M255562 maxgro 2014-07-03T16:54:02Z