topic Re: CALCULATE DATE in QlikView https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9163#M776108 <HTML><HEAD></HEAD><BODY><P>Great.</P><P>its working.</P><P>Thanks</P></BODY></HTML> Tue, 24 Apr 2018 11:47:33 GMT razyorazyo 2018-04-24T11:47:33Z CALCULATE DATE https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9161#M776106 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have field which its type is AlphaNumeri and contains date of the following format :20180424.</P><P>2018 - year</P><P>04 - month</P><P>24 - day</P><P></P><P>I need to relate each date to right week of the year and I do it with interval match command.</P><P></P><P>now ,I need , for each date ,to calculate the date 7 days before and then relate&nbsp; it to the correct week.</P><P></P><P>how can I calculate the new date without changing its format or calculate and converting the new date to the original format?</P><P></P><P>Thanks</P><P>Raz</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9161#M776106 razyorazyo 2020-11-25T16:16:04Z Re: CALCULATE DATE https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9162#M776107 <HTML><HEAD></HEAD><BODY><P> Date(Date#(20180424,'YYYYMMDD')+7,'YYYYMMDD')</P></BODY></HTML> Tue, 24 Apr 2018 11:23:53 GMT https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9162#M776107 sasiparupudi1 2018-04-24T11:23:53Z Re: CALCULATE DATE https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9163#M776108 <HTML><HEAD></HEAD><BODY><P>Great.</P><P>its working.</P><P>Thanks</P></BODY></HTML> Tue, 24 Apr 2018 11:47:33 GMT https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9163#M776108 razyorazyo 2018-04-24T11:47:33Z Re: CALCULATE DATE https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9164#M776109 <HTML><HEAD></HEAD><BODY><P>Great, pl close this thread by marking a correct and any helpful answers</P></BODY></HTML> Tue, 24 Apr 2018 11:54:18 GMT https://community.qlik.com/t5/QlikView/CALCULATE-DATE/m-p/9164#M776109 sasiparupudi1 2018-04-24T11:54:18Z