Results 1 to 1 of 1
2010-01-15, 21:38 #1
- Join Date
- Nov 2001
- Brisbane, Queensland, Australia
- Thanked 0 Times in 0 Posts
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!"Heading for the deep end"