topic How to generate dates in QlikView https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760354#M270548 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have created the following calendar in my script in order to look at each cover day for each policy. I now need to calculate the date for each policy date by adding one to each date up to 365 i.e. if a policy starts on 2/12/2014 I want this to be marked as coverday 1, 3/12/2014 to be coverday 2 etc. I am struggling to get this to work. Does anyone have any ideas?</P></BODY></HTML> Tue, 02 Dec 2014 14:51:22 GMT 2014-12-02T14:51:22Z How to generate dates https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760354#M270548 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have created the following calendar in my script in order to look at each cover day for each policy. I now need to calculate the date for each policy date by adding one to each date up to 365 i.e. if a policy starts on 2/12/2014 I want this to be marked as coverday 1, 3/12/2014 to be coverday 2 etc. I am struggling to get this to work. Does anyone have any ideas?</P></BODY></HTML> Tue, 02 Dec 2014 14:51:22 GMT https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760354#M270548 2014-12-02T14:51:22Z Re: How to generate dates https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760355#M270549 <HTML><HEAD></HEAD><BODY><P>From which date you wish to calculate?</P><P>Why not using a straightforward formula:</P><P></P><P>MyDate - StartDate + 1 = coverday</P><P></P><P>(plus probably adding some formula to detect the expiry of the policy)</P><P></P><P>HTH Peter</P></BODY></HTML> Tue, 02 Dec 2014 16:03:54 GMT https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760355#M270549 prieper 2014-12-02T16:03:54Z Re: How to generate dates https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760356#M270550 <HTML><HEAD></HEAD><BODY><P>Thanks Peter, this is something similar to the solution I have found.</P></BODY></HTML> Thu, 04 Dec 2014 12:07:27 GMT https://community.qlik.com/t5/QlikView/How-to-generate-dates/m-p/760356#M270550 2014-12-04T12:07:27Z