Sorting numerically fails.
Date |
Description |
Progress |
01-05-05 |
Nothing better to do! Duh!? |
100% |
02-09-05 |
Now we are progressing |
95% |
01-02-06 |
It's ok, we are almost there |
99% |
04-06-07 |
Ok, we are way beyond our timeline |
100% |
- Date is sorted fine, but doesn't coincide with Month and Year.
- Percentage 95% and 99% i.e. 100%, 100%, 95%, 99%
- Date is the same as above
- Percentage is GOOD.
Even for Alpha numeric input for Date doesn't do that well, Full year,
Date |
Description |
Progress |
01 May 2005 |
Nothing better to do! Duh!? |
100% |
02 Sept 2005 |
Now we are progressing |
95% |
01 Feb 2006 |
It's ok, we are almost there |
99% |
04 June 2007 |
Ok, we are way beyond our timeline |
100% |
Double digit year,
Date |
Description |
Progress |
01 May 05 |
Nothing better to do! Duh!? |
100% |
02 Sept 05 |
Now we are progressing |
95% |
01 Feb 06 |
It's ok, we are almost there |
99% |
04 June 07 |
Ok, we are way beyond our timeline |
100% |
Nothing major in a way.
--
TWiki:Main/KwangErnLiew - 16 Mar 2007
- Rule 1: you need TablePlugin, so insert == above the table
- Rule 2: TablePlugin says:
date if format is:
* dd MMM YYYY - hh:mm (MMM is Jan, Feb, etc.)
* dd-MMM-YY or dd-MMM-YYYY (can be / or space in place of -) (MMM is Jan, Feb, etc)
So no
Sept
but
Sep
; no
01-05-05
but
01 May 2005
Using the correct format:
Date |
Description |
Progress |
01 May 2005 |
Nothing better to do! Duh!? |
100% |
02 Sep 2005 |
Now we are progressing |
95% |
01 Feb 2006 |
It's ok, we are almost there |
99% |
04 Jun 2007 |
Ok, we are way beyond our timeline |
100% |
--
TWiki:Main.ArthurClemens - 19 Nov 2007