>That is a good question. This is a set of tasks to be done as a project. The owner could ask for an extension. So I need to find the task with latest date an change that date to extended date. So I guess in the case of duplicates it would be okay to chane all of them to new date.
Can you post your problem with DDL of the table(s) involved, some insert data scripts and desired output?
If it's not broken, fix it until it is.
My Blog