https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743634#M720776 <P>Hello,</P><P>I have a table with different dates in a field named DOC_DATE format MM/DD/YYYY.</P><P>What I need is to create a new field from DOC DATE, named PAY_DATE, with the next friday to that date.</P><P>So I should get something like the following:</P><TABLE border="0" width="160" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">DOC_DATE</TD><TD width="80">PAY_DATE</TD></TR><TR><TD height="20">9/7/2020</TD><TD>9/11/2020</TD></TR><TR><TD height="20">9/10/2020</TD><TD>9/11/2020</TD></TR><TR><TD height="20">9/11/2020</TD><TD>9/11/2020</TD></TR><TR><TD height="20">9/12/2020</TD><TD>9/18/2020</TD></TR><TR><TD height="20">9/13/2020</TD><TD>9/18/2020</TD></TR><TR><TD height="20">9/14/2020</TD><TD>9/18/2020</TD></TR><TR><TD height="20">9/15/2020</TD><TD>9/18/2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any way to do that by script?</P><P>Thank you!!!</P> Wed, 25 Nov 2020 16:16:04 GMT AleRods88 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743634#M720776 <P>Hello,</P><P>I have a table with different dates in a field named DOC_DATE format MM/DD/YYYY.</P><P>What I need is to create a new field from DOC DATE, named PAY_DATE, with the next friday to that date.</P><P>So I should get something like the following:</P><TABLE border="0" width="160" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">DOC_DATE</TD><TD width="80">PAY_DATE</TD></TR><TR><TD height="20">9/7/2020</TD><TD>9/11/2020</TD></TR><TR><TD height="20">9/10/2020</TD><TD>9/11/2020</TD></TR><TR><TD height="20">9/11/2020</TD><TD>9/11/2020</TD></TR><TR><TD height="20">9/12/2020</TD><TD>9/18/2020</TD></TR><TR><TD height="20">9/13/2020</TD><TD>9/18/2020</TD></TR><TR><TD height="20">9/14/2020</TD><TD>9/18/2020</TD></TR><TR><TD height="20">9/15/2020</TD><TD>9/18/2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any way to do that by script?</P><P>Thank you!!!</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743634#M720776 AleRods88 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743658#M720777 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/94877">@AleRods88</a>&nbsp; Assuming your Date Field are in proper date format. You can try below</P><LI-CODE lang="javascript">date(if(WeekDay(DOC_DATE,0)=4,DOC_DATE, WeekEnd(DOC_DATE,0,4)+1)) as PAY_DATE</LI-CODE> Mon, 14 Sep 2020 15:15:22 GMT https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743658#M720777 Kushal_Chawda 2020-09-14T15:15:22Z https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743663#M720778 <P>Thank you very much! It worked!!!</P> Mon, 14 Sep 2020 15:32:24 GMT https://community.qlik.com/t5/QlikView/Get-Next-Friday-from-a-Date/m-p/1743663#M720778 AleRods88 2020-09-14T15:32:24Z