Sort as a date

Replying to rennerocha:

Actually, the fields are sorted as a 'text' field. It will be nice if we can sort the 'date' fields as a real date.

Workaround: use format=ymd. Sorting works well then.

Replying to anonymous:

Replying to rennerocha:

Actually, the fields are sorted as a 'text' field. It will be nice if we can sort the 'date' fields as a real date.

Workaround: use format=ymd. Sorting works well then.

Thanks! I am already using that. But here (in Brazil) it is uncommon the form 'ymd'. It will be better for the end users to be able to insert the data in 'dmy' form and have it sorted correctly.

Replying to rennerocha:

Actually, the fields are sorted as a 'text' field. It will be nice if we can sort the 'date' fields as a real date.

I faced the same problem in reports. Here is my solution: I transform the datestring to time in the sql-query of the reports!

SELECT ... cCur.value AS Current_Due, ...
FROM ticket t
LEFT OUTER JOIN ticket_custom cDue ON (t.id = cDue.ticket AND cDue.name = 'due_date')
... ORDER BY
strftime('%s',substr(cDue.value,7,4)||"-"||substr(cDue.value,4,2)||"-"||substr(cDue.value,1,2))

my custum ticket is named due_date.

By the way: you can filter tickets by comparing the Due date i.e. with the actual date.

... < strftime('%s',date('now'))

Here is micro (Trac) patch to enable sorting in custom query results. Postgres only + hardcoded to due_assign, due_close in DD-MM-YYYY format, I put it up so others have a place to start if interested:

Index: trac/ticket/query.py
===================================================================
--- trac/ticket/query.py        (revision 8858)
+++ trac/ticket/query.py        (working copy)
@@ -537,6 +537,10 @@
             #        one, if text, we do 'else'
             if name in ('id', 'time', 'changetime'):
                 sql.append("COALESCE(%s,0)=0%s," % (col, desc))
+            elif name in ('due_assign', 'due_close'):
+                # invert sort order
+                mydesc = desc!=' DESC' and ' DESC' or ''
+                sql.append("TO_TIMESTAMP(COALESCE(%s, '01-01-1970'), 'DD-MM-YYYY')%s," % (col, mydesc))
             else:
                 sql.append("COALESCE(%s,'')=''%s," % (col, desc))
             if name in enum_columns:

See also #8964.

Update on plugin development: It will not be the aim of DateFieldPlugin to support a true date type, rather, just provide a datepicker for input fields. See #8964 for more details. True date type support is coming to the Trac core in the near future (see t:#1942).