https://community.qlik.com/t5/QlikView/Provisioning-dates-Generate-startDate-and-endDate/m-p/1587412#M596164 <P>Hi all,&nbsp;</P><P>First of all thanks in advance for the future help.</P><P>I am struggling quite a littel bit with something that might be easy for top users.</P><P>I have this table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>customer</TD><TD>date</TD></TR><TR><TD>Luis</TD><TD>01/01/2019</TD></TR><TR><TD>Carl</TD><TD>01/01/2019</TD></TR><TR><TD>John</TD><TD>05/01/2019</TD></TR><TR><TD>Luis</TD><TD>03/01/2019</TD></TR><TR><TD>Carl</TD><TD>08/01/2019</TD></TR><TR><TD>John</TD><TD>10/01/2019</TD></TR><TR><TD>Luis</TD><TD>15/01/2019</TD></TR><TR><TD>Carl</TD><TD>16/01/2019</TD></TR><TR><TD>John</TD><TD>20/01/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And I want to process it and convert it into:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>customer</TD><TD>dateStart</TD><TD>datEnd</TD></TR><TR><TD>Luis</TD><TD>01/01/2019</TD><TD>02/01/2019</TD></TR><TR><TD>Carl</TD><TD>01/01/2019</TD><TD>07/01/2019</TD></TR><TR><TD>John</TD><TD>05/01/2019</TD><TD>09/01/2019</TD></TR><TR><TD>Luis</TD><TD>03/01/2019</TD><TD>14/01/2019</TD></TR><TR><TD>Carl</TD><TD>08/01/2019</TD><TD>15/01/2019</TD></TR><TR><TD>John</TD><TD>10/01/2019</TD><TD>19/01/2019</TD></TR><TR><TD>Luis</TD><TD>15/01/2019</TD><TD>31/12/2999</TD></TR><TR><TD>Carl</TD><TD>16/01/2019</TD><TD>31/12/2999</TD></TR><TR><TD>John</TD><TD>20/01/2019</TD><TD>31/12/2999</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any idea? I guess it has to be easy but I cannot find the solution.</P><P>Kind regards</P> Sat, 16 Nov 2024 20:44:36 GMT lfalmoguera 2024-11-16T20:44:36Z https://community.qlik.com/t5/QlikView/Provisioning-dates-Generate-startDate-and-endDate/m-p/1587412#M596164 <P>Hi all,&nbsp;</P><P>First of all thanks in advance for the future help.</P><P>I am struggling quite a littel bit with something that might be easy for top users.</P><P>I have this table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>customer</TD><TD>date</TD></TR><TR><TD>Luis</TD><TD>01/01/2019</TD></TR><TR><TD>Carl</TD><TD>01/01/2019</TD></TR><TR><TD>John</TD><TD>05/01/2019</TD></TR><TR><TD>Luis</TD><TD>03/01/2019</TD></TR><TR><TD>Carl</TD><TD>08/01/2019</TD></TR><TR><TD>John</TD><TD>10/01/2019</TD></TR><TR><TD>Luis</TD><TD>15/01/2019</TD></TR><TR><TD>Carl</TD><TD>16/01/2019</TD></TR><TR><TD>John</TD><TD>20/01/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And I want to process it and convert it into:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>customer</TD><TD>dateStart</TD><TD>datEnd</TD></TR><TR><TD>Luis</TD><TD>01/01/2019</TD><TD>02/01/2019</TD></TR><TR><TD>Carl</TD><TD>01/01/2019</TD><TD>07/01/2019</TD></TR><TR><TD>John</TD><TD>05/01/2019</TD><TD>09/01/2019</TD></TR><TR><TD>Luis</TD><TD>03/01/2019</TD><TD>14/01/2019</TD></TR><TR><TD>Carl</TD><TD>08/01/2019</TD><TD>15/01/2019</TD></TR><TR><TD>John</TD><TD>10/01/2019</TD><TD>19/01/2019</TD></TR><TR><TD>Luis</TD><TD>15/01/2019</TD><TD>31/12/2999</TD></TR><TR><TD>Carl</TD><TD>16/01/2019</TD><TD>31/12/2999</TD></TR><TR><TD>John</TD><TD>20/01/2019</TD><TD>31/12/2999</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any idea? I guess it has to be easy but I cannot find the solution.</P><P>Kind regards</P> Sat, 16 Nov 2024 20:44:36 GMT https://community.qlik.com/t5/QlikView/Provisioning-dates-Generate-startDate-and-endDate/m-p/1587412#M596164 lfalmoguera 2024-11-16T20:44:36Z https://community.qlik.com/t5/QlikView/Provisioning-dates-Generate-startDate-and-endDate/m-p/1587442#M596165 <P>This is a duplicate, answered <A href="https://community.qlik.com/t5/New-to-QlikView/Generate-Calendar-Start-Date-and-Start-End-for-Effective-Dates/td-p/1586348" target="_self">here</A></P> Mon, 03 Jun 2019 05:55:50 GMT https://community.qlik.com/t5/QlikView/Provisioning-dates-Generate-startDate-and-endDate/m-p/1587442#M596165 jonathandienst 2019-06-03T05:55:50Z