topic Need WeekEnd Friday, instead of Sunday in QlikView https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126499#M370731 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a field within my load script for "Week Ending" where our weeks end at the end of every Friday.</P><P>I'm able to use the WeekEnd function and get a "Week Ending"&nbsp; date in my tables using the following load statement, but it returns the standard "Week Ending" date of end of every Sunday.&nbsp; Does anyone know how I can modify the script to subtract 2 days to get my weeks to end on Friday?</P><P></P><P>This is the load statement that has worked for me so far to get Week Ending as of end of Sunday:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">WeekEnd</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">D</SPAN><SPAN style="font-size: 8pt;">), 'MM/DD/YY') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Week Ending] </SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 8pt;">NOTE:&nbsp; "D"=my date field (which is not in MM/DD/YY format)</SPAN></P></BODY></HTML> Wed, 11 May 2016 17:06:22 GMT 2016-05-11T17:06:22Z Need WeekEnd Friday, instead of Sunday https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126499#M370731 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a field within my load script for "Week Ending" where our weeks end at the end of every Friday.</P><P>I'm able to use the WeekEnd function and get a "Week Ending"&nbsp; date in my tables using the following load statement, but it returns the standard "Week Ending" date of end of every Sunday.&nbsp; Does anyone know how I can modify the script to subtract 2 days to get my weeks to end on Friday?</P><P></P><P>This is the load statement that has worked for me so far to get Week Ending as of end of Sunday:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">WeekEnd</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">D</SPAN><SPAN style="font-size: 8pt;">), 'MM/DD/YY') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Week Ending] </SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 8pt;">NOTE:&nbsp; "D"=my date field (which is not in MM/DD/YY format)</SPAN></P></BODY></HTML> Wed, 11 May 2016 17:06:22 GMT https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126499#M370731 2016-05-11T17:06:22Z Re: Need WeekEnd Friday, instead of Sunday https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126500#M370732 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">May be like this:</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #575757;"><STRONG>Date</STRONG><STRONG>(WeekEnd(D, 0, 5), 'MM/DD/YY') as </STRONG></SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;"><STRONG style=": ; color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">[Week Ending]</STRONG></SPAN></P></BODY></HTML> Wed, 11 May 2016 17:48:18 GMT https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126500#M370732 sunny_talwar 2016-05-11T17:48:18Z Re: Need WeekEnd Friday, instead of Sunday https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126501#M370733 <HTML><HEAD></HEAD><BODY><P>Yes, that worked!&nbsp; Thank you!</P></BODY></HTML> Wed, 11 May 2016 17:54:38 GMT https://community.qlik.com/t5/QlikView/Need-WeekEnd-Friday-instead-of-Sunday/m-p/1126501#M370733 2016-05-11T17:54:38Z