Need help in Sorting in VSFlexGrid

[Bangaru]

the problem is I have the code, sorting as below in the VSFlexGrid:

VSFlexGrid1.Sort = flexSortStringNoCaseAscending

I have a column that displays both Date and time

When I get this grid populated the first time, the Sort works.
when I select a different condition to populate the Grid, then when I sort clicking on the column that has both Date and time, it doesn't.
what happens is that it results the Grid with all 01/03/2005 00:00:00 data
i.e., it sorts only according to day

Hence I get the data from same day but different month and year together.

But whenever the condition changes, the below line gets executed
VSFlexGrid1.Sort = flexSortStringNoCaseAscending

Any help in this regard is appreciated

Regards,
Priya