Message Thread: |
View All MessagesBack to WebFX |
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. 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) |