topic Re: Changing all Monday dates to previous Friday dates in QlikView https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211016#M388448 <HTML><HEAD></HEAD><BODY><P>It works, thanks a lot!</P></BODY></HTML> Fri, 21 Oct 2016 19:18:47 GMT Anonymous 2016-10-21T19:18:47Z Changing all Monday dates to previous Friday dates https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211014#M388446 <HTML><HEAD></HEAD><BODY><P>I have a column in my database (Post_Date)&nbsp; and I need all the Monday dates in that column to point to the previous Friday date. In other words if the Post_Date day is a Monday, it should show the Post_Date to be that of the Friday before. </P></BODY></HTML> Fri, 21 Oct 2016 19:03:58 GMT https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211014#M388446 Anonymous 2016-10-21T19:03:58Z Re: Changing all Monday dates to previous Friday dates https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211015#M388447 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Date(If(WeekDay(Post_Date) = 'Mon', Post_Date - 3, Post_Date)) as Post_Date</STRONG></P></BODY></HTML> Fri, 21 Oct 2016 19:06:52 GMT https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211015#M388447 sunny_talwar 2016-10-21T19:06:52Z Re: Changing all Monday dates to previous Friday dates https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211016#M388448 <HTML><HEAD></HEAD><BODY><P>It works, thanks a lot!</P></BODY></HTML> Fri, 21 Oct 2016 19:18:47 GMT https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211016#M388448 Anonymous 2016-10-21T19:18:47Z Re: Changing all Monday dates to previous Friday dates https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211017#M388449 <HTML><HEAD></HEAD><BODY><P>It works only if the column name is changed:</P><P></P><P><STRONG>Date(If(WeekDay(Post_Date) = 'Mon', Post_Date - 3, Post_Date)) as Rev_Post_Date</STRONG></P><P></P><P>But when I try to use the revised column name for another IF condition in the script, it does not recognize it. </P></BODY></HTML> Fri, 21 Oct 2016 20:09:32 GMT https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211017#M388449 Anonymous 2016-10-21T20:09:32Z Re: Changing all Monday dates to previous Friday dates https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211018#M388450 <HTML><HEAD></HEAD><BODY><P>That is strange, can you share the complete script and where the issue is?</P></BODY></HTML> Fri, 21 Oct 2016 20:27:52 GMT https://community.qlik.com/t5/QlikView/Changing-all-Monday-dates-to-previous-Friday-dates/m-p/1211018#M388450 sunny_talwar 2016-10-21T20:27:52Z