https://community.qlik.com/t5/QlikView/Date-range/m-p/1880738#M1216839 <P>Hi,</P> <P>i am generating dates from start date to end date, but end date is max date of (original_PPAP, new_PPAP) max one will consider as end date.</P> <TABLE width="239"> <TBODY> <TR> <TD width="70">start_date</TD> <TD width="95">original_PPAP</TD> <TD width="74">new_PPAP</TD> </TR> <TR> <TD>2021-08-03</TD> <TD>10/14/2022</TD> <TD>6/26/2023</TD> </TR> <TR> <TD>2021-08-03</TD> <TD>7/23/2022</TD> <TD>5/31/2022</TD> </TR> <TR> <TD>2021-08-03</TD> <TD>4/9/2022</TD> <TD>4/9/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>LOAD [Study #],</P> <P>Date(start_date + IterNo() - 1) as Date_Range<BR />RESIDENT Input_Data<BR />While Date(start_date + IterNo() - 1) &lt;= Original_PPAP<BR />;</P> <P>for one field the dates are generating,</P> <P>please help me for generating dates for end date max one.</P> Thu, 13 Jan 2022 15:09:06 GMT nvijay5757 2022-01-13T15:09:06Z https://community.qlik.com/t5/QlikView/Date-range/m-p/1880738#M1216839 <P>Hi,</P> <P>i am generating dates from start date to end date, but end date is max date of (original_PPAP, new_PPAP) max one will consider as end date.</P> <TABLE width="239"> <TBODY> <TR> <TD width="70">start_date</TD> <TD width="95">original_PPAP</TD> <TD width="74">new_PPAP</TD> </TR> <TR> <TD>2021-08-03</TD> <TD>10/14/2022</TD> <TD>6/26/2023</TD> </TR> <TR> <TD>2021-08-03</TD> <TD>7/23/2022</TD> <TD>5/31/2022</TD> </TR> <TR> <TD>2021-08-03</TD> <TD>4/9/2022</TD> <TD>4/9/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>LOAD [Study #],</P> <P>Date(start_date + IterNo() - 1) as Date_Range<BR />RESIDENT Input_Data<BR />While Date(start_date + IterNo() - 1) &lt;= Original_PPAP<BR />;</P> <P>for one field the dates are generating,</P> <P>please help me for generating dates for end date max one.</P> Thu, 13 Jan 2022 15:09:06 GMT https://community.qlik.com/t5/QlikView/Date-range/m-p/1880738#M1216839 nvijay5757 2022-01-13T15:09:06Z https://community.qlik.com/t5/QlikView/Date-range/m-p/1880770#M1216841 <P>RangeMax<SPAN>(original_PPAP, new_PPAP)</SPAN></P> <P><SPAN>-Rob</SPAN></P> Thu, 13 Jan 2022 15:53:31 GMT https://community.qlik.com/t5/QlikView/Date-range/m-p/1880770#M1216841 rwunderlich 2022-01-13T15:53:31Z