||View All MessagesBack to WebFX|
First off, thanks for the prompt response.
Secondly, can you or someone please show me an example of how you would "HIDE" the this column. I understand the concept, in fact i've even tried it myself. but I guess this is really where the magic in solving this problem is.
thanks in advance.
From: Jeffrey Jangli
Sent: December 23, 2004
Subject: Re:Sortable Tables - Sort column according to hidden value (is this case a date)
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
The trick is to HIDE the ISO_DATE colum, so that it only displays like so:
3 22 december Blaa 1
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.
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)