=== UPDATE other than Location example ===__NOEDITSECTION__
Note in this example The difficulty is to how to identify which link row to transform to ''NEW''. I use have tried Min(fieldreport.dateofreport) and Min("public"hazardinfoversion.dataentrydate). It is difficult to judge which one is better by the dates themselves due to data entry might have been done quite later than Date of Information. For Afghanistan I had 234 missing links and then comparing the two options 211 were the same.I decided that Min(fieldreport.dateofreport) which was the best option in which I also used for South Sudan (another option would be hazardinfoversion.dataentrydate).
<pre>
UPDATE link