Create an index on the date field using DTOS(DateField) and simply add the following to the Click event of Grid's Column's Header.

*-- Grid.Column.Header.Click()
SELECT (this.Parent.Parent.RecordSource)
SET ORDER TO TAG NewTagNameofDateField

>I have a grid with 2 fields , the first field is a date field.I want to sort data in such a way that when I click the header of date field it sorts the dates in such a way that the dates are displayed chronologically i.e. 1-1-98 , 1-2-98 , 1-3-98 and so on... I have tried it with SORT MYDATETABLE ON DATEBOX /ASCENDING
>but to no avail.Your help will be most appreciated.I would like to thank Jess Banga for his help for my last query.
>Thank You All........
>Zaraq Bari