Crystal Reports XI ?

[JackVol]

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

[jggtz]

Just add a new formula field an concatenate the two date fields into one, you coud use the ToText function to do it
After that you could set that formula field in the report sort

JG