I have a list, that displays there columns,one of them is a date field and when I go into properties I can assign sorting properties for each of those column,so that is what I have done.

But the product of the date field sort is that the field is sorted like (1 apr 1999, 1 apr 2000) so it really sorts by the first digit, insted of looking at the date as a whole.

i am not aware if we can do anything to get this to sort the way I need it, and if not how would you do it and can it be done, I am sure it can.

Thanks