Thread: "New" sort in text column
View Single Post
Old 03-14-2012, 01:10 AM   #10
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
I had a play with the suggestion I made. Unfortunately, it didn't work.

I added two columns:

- #year - Integer
- #yearepoch - a column based on another.

For the #yearepoch, I used the template:

{#year:'cmp($, 0, multiply($, -1), $, $)'} {#year:'cmp($, 0, 'BBY', 'ABY', 'ABY')'}

This gives a display like what was asked for. Unfortunately, the sorting is based on the displayed data, not the value of #year.
davidfor is offline   Reply With Quote