Sorting a formula field in Crystal Reports XI

[bebore]

Hi,
I've created a Crystal Report containing DateTime, Cli info and queueing information. I need to sort the DateTime colomn asc. From the database side I order by DateTime (asc) and it looks fine. On Crystal I have to format this dateTime to GMT+2 - all is still fine. Problem is that I cannot get DateTime on Crystal to appear asc ? Can I do an order on a formula field in Crystal?

 

[lbass]

Go to report->sort records and add either the datetime field or the formula as a sort field.

-LB