topic convert weekday to a date in QlikView https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460194#M1153360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list of articles and weekdays they arrive.</P><P></P><P>Example:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Article</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ArrivalDay 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ArrivalDay 2</STRONG></SPAN></TH></TR><TR><TD>Article1</TD><TD>Monday</TD><TD>Friday</TD></TR><TR><TD>Article2</TD><TD>Wedensday</TD><TD>Friday</TD></TR><TR><TD>Article3</TD><TD>Monday</TD><TD>Tuesday</TD></TR><TR><TD>Article4</TD><TD>Tuesday</TD><TD>Thursday</TD></TR></TBODY></TABLE><P></P><P>Today is 20-03-2013, and I wonder if there is any way to convert the weekdays to Dates... The date should be the first upcoming date (or todays date) that matches the weekday.. euhm.. my bad english makes it hard to explain <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Anyway, result that I want is this:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Article</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ArrivalDate 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Arrival Date 2</STRONG></SPAN></TH></TR><TR><TD>Article1</TD><TD>25-03-2013</TD><TD>22-03-2013</TD></TR><TR><TD>Article2</TD><TD>20-03-2013</TD><TD>22-03-2013</TD></TR><TR><TD>Article3</TD><TD>25-03-2013</TD><TD>26-03-2013</TD></TR><TR><TD>Article4</TD><TD>26-03-2013</TD><TD>28-03-2013</TD></TR></TBODY></TABLE><P></P><P>Any help is appreciated</P><P></P><P>thanks in advance.</P></BODY></HTML> Wed, 20 Mar 2013 12:17:01 GMT 2013-03-20T12:17:01Z convert weekday to a date https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460194#M1153360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list of articles and weekdays they arrive.</P><P></P><P>Example:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Article</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ArrivalDay 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ArrivalDay 2</STRONG></SPAN></TH></TR><TR><TD>Article1</TD><TD>Monday</TD><TD>Friday</TD></TR><TR><TD>Article2</TD><TD>Wedensday</TD><TD>Friday</TD></TR><TR><TD>Article3</TD><TD>Monday</TD><TD>Tuesday</TD></TR><TR><TD>Article4</TD><TD>Tuesday</TD><TD>Thursday</TD></TR></TBODY></TABLE><P></P><P>Today is 20-03-2013, and I wonder if there is any way to convert the weekdays to Dates... The date should be the first upcoming date (or todays date) that matches the weekday.. euhm.. my bad english makes it hard to explain <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Anyway, result that I want is this:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Article</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ArrivalDate 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Arrival Date 2</STRONG></SPAN></TH></TR><TR><TD>Article1</TD><TD>25-03-2013</TD><TD>22-03-2013</TD></TR><TR><TD>Article2</TD><TD>20-03-2013</TD><TD>22-03-2013</TD></TR><TR><TD>Article3</TD><TD>25-03-2013</TD><TD>26-03-2013</TD></TR><TR><TD>Article4</TD><TD>26-03-2013</TD><TD>28-03-2013</TD></TR></TBODY></TABLE><P></P><P>Any help is appreciated</P><P></P><P>thanks in advance.</P></BODY></HTML> Wed, 20 Mar 2013 12:17:01 GMT https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460194#M1153360 2013-03-20T12:17:01Z Re: convert weekday to a date https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460195#M1153361 <HTML><HEAD></HEAD><BODY><P>See attached example</P></BODY></HTML> Wed, 20 Mar 2013 13:10:16 GMT https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460195#M1153361 Gysbert_Wassenaar 2013-03-20T13:10:16Z Re: convert weekday to a date https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460196#M1153362 <HTML><HEAD></HEAD><BODY><P>Thanks you so much, that´s awesome!</P><P>I haven´t really figured out how it works yet but hopefully I will <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 20 Mar 2013 13:48:48 GMT https://community.qlik.com/t5/QlikView/convert-weekday-to-a-date/m-p/460196#M1153362 2013-03-20T13:48:48Z