Most recent record based on date column

I have a table loaded from an odatafeed with regular refreshes that has a lot of column but following 2 are the most important for this question;   table incidents - incidentnumber - modification...