I am trying to write a small reminder program in VB Express 2008.

I am reading a text file into a dataGridView control

My date column is sorted using the following command : DataGridView1.Sort(DueDate, System.ComponentModel.ListSortDirection.Ascending) but it is only a character sort.

If I import dates as yyyy/mm/dd then it sorts ok but I want to use dd/mm/yyyy dates as I am using DateTimePicker as part of my entering new items process and that is the way that it gives it to me (dd/mm/yyyy)


Is there a way to make my grid sort correctly by date rather than by characters?

EDIT: Thought.... can I convert a date to some sort of number value, stick that in a hidden column and then sort by it?

....Yes I can....Done!