Hello,
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.
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.
How can I achieve this? Many thanks in advance.
