Yes this is possible!
Let me try to explain, i use this table:
ID ISO_DATE NICE_DATE DESCRIPTION
3 20041222 22 december Blaa 1
4 20041219 19 december Blaa 2
The trick is to HIDE the ISO_DATE colum, so that it only displays like so:
ID NICE_DATE DESCRIPTION
3 22 december Blaa 1
4 19 december Blaa 2
But you can still use the ISO_DATE column for sorting when clicked on the header, the NICE_DATE column will then always be sorted right.
Jeffrey
Is it possible to display a date like "Dec 22" , "Jan 5th". But sort according to a hidden date i.e. (Dec 1, 12-01-04) (Dec 22, 12-22-04) and (Jan 5, 01-05-05), (Feb 15, 02-15-05)
Such that the resulting sort would be as follows:
(Dec 1,Dec 22, Jan 5, Feb 15) or (Feb 15, Jan 5, Dec 22, Dec 1)
Sortable Tables - Sort column according to hidden value (is this case a date), Pete, December 22, 2004
