topic Re: Dates in a week in QlikView https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779906#M534983 <HTML><HEAD></HEAD><BODY><P>Are these weeks normal calender weeks - if so above comment should work</P></BODY></HTML> Wed, 28 Jan 2015 14:13:26 GMT Anonymous 2015-01-28T14:13:26Z Dates in a week https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779904#M534981 <HTML><HEAD></HEAD><BODY><P>I have a report comparing performance between 2 different weeks.</P><P>I allow the 2 weeks to be selected in format YYYYww.</P><P>Once selected, I would like to display the date range for the week selected eg.</P><P></P><P>2015 04 would have the range 25Jan2015 - 31Jan2015.</P><P></P><P>Any neat ideas how to do this ?</P><P>Thanks</P><P>Richard</P></BODY></HTML> Wed, 28 Jan 2015 13:55:38 GMT https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779904#M534981 richard_chilvers 2015-01-28T13:55:38Z Re: Dates in a week https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779905#M534982 <HTML><HEAD></HEAD><BODY><P>Try</P><P>= WeekStart(DateField) &amp; ' - ' &amp; WeekEnd(DateField)</P><P><BR /> </P></BODY></HTML> Wed, 28 Jan 2015 14:08:42 GMT https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779905#M534982 Colin-Albert 2015-01-28T14:08:42Z Re: Dates in a week https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779906#M534983 <HTML><HEAD></HEAD><BODY><P>Are these weeks normal calender weeks - if so above comment should work</P></BODY></HTML> Wed, 28 Jan 2015 14:13:26 GMT https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779906#M534983 Anonymous 2015-01-28T14:13:26Z Re: Dates in a week https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779907#M534984 <HTML><HEAD></HEAD><BODY><P>Thanks.</P><P>I felt sure someone would have a neat solution - I just need to sort out the formatting of <EM>DateField</EM> and it will be ideal.</P><P></P><P>Richard</P></BODY></HTML> Wed, 28 Jan 2015 14:13:30 GMT https://community.qlik.com/t5/QlikView/Dates-in-a-week/m-p/779907#M534984 richard_chilvers 2015-01-28T14:13:30Z