I am trying to merge 2 date fields into 1 column and sort them together on a report.

Inv Dt Trans Dt New Col
1/12/10 2/1/10 1/12/10
2/1/10

The data is coming from an xml File generated in Epicor, so I don't have acces to change way data is coming to report Does anyone know of a way to accomplish this ?

Thanks