Reporting based on 1 of 2 date fields

[JJR]

I have created a report that, among other fields, contains two date fields. 1 field named planned ship date and 1 field named revised ship date. The planned ship date field always has a date entered. The revised ship date field occasionally has a date entered in it. I need to sort these records based on which ever field has the later date and the report needs to display each field.

Any help would be much appreciated.

[mr_vodka]

You can create a calc of Max ( DateShip; DateRevise ) and then sort on that.