Option 1:
You can bring the data already sorted:
SELECT * FROM MyTable ORDER BY MyDate
Option 2:
Or you can use the table property of Crystal Report and select the column to be ordered. ( Use the Report --> Record Sort Expert --> and choose the formula from the report fields window.)