topic Find and change first date on table in QlikView https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207971#M63542 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see the attached example. Open script editor last LOAD statement.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 09 Feb 2011 14:53:00 GMT 2011-02-09T14:53:00Z Find and change first date on table https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207970#M63541 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to load a table from SQL with two fields: dates and product codes. A single product code can have many dates. The table comes ordered by date and then by product code.</P><P>I would like to change the first of the dates that a product code holds, for a specific date (01/01/2001): if, for example product A has dates 5/9/2007, 6/8/2009 and 5/7/2010, then I need the first of them to be converted to 01/01/2001.</P><P>How can I achieve this? Many thanks in advance.</P></BODY></HTML> Wed, 09 Feb 2011 14:19:02 GMT https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207970#M63541 salto 2011-02-09T14:19:02Z Find and change first date on table https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207971#M63542 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see the attached example. Open script editor last LOAD statement.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 09 Feb 2011 14:53:00 GMT https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207971#M63542 2011-02-09T14:53:00Z Find and change first date on table https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207972#M63543 <HTML><HEAD></HEAD><BODY><P>Many thanks!</P><P>Brilliant. It solved the problem.</P></BODY></HTML> Thu, 10 Feb 2011 11:23:05 GMT https://community.qlik.com/t5/QlikView/Find-and-change-first-date-on-table/m-p/207972#M63543 salto 2011-02-10T11:23:05Z