Report doesn't filter by date

• Error
• Consistency

Report doesn't seem to filter by date as it's supposed to do.

I select to list only values after a date (by the way, how does report know that this field is supposed to be the start date? just because is the first one of a couple of consecutive date fields in a tracker?), and value before that date are also shown.

I mean, we have a tracker with several date fields (4 in fact) for project management:

• when the project was requested
• when the project started
• when the project is due to be finished
• the date of the next deadline to meet within the project timeframe.

Ideally, the user should be offered the option to select which tracker field want to use as a start date for the filter, and which one as the end date for the filter. And not just the creation date or the modification date.

Right now, it seems to be using either the creation or modification date of the tracker item? (which is less useful and less versatile than what it could be with the previous improvement of the design)

The other things that might be affecting the missbehavior of the filtering by date is that the date field in a tracker can be set either by using the "Date and time" tracker field, and the "Date and time (Date Picker)" (jquery) tracker field.
See http://doc.tiki.org/Date+Tracker+Fields

They both seem (from the end user point of view) to have different way to store data:

• JQuery date picker from the tracker-field "Date and time (Date Picker)" seems to use this syntax for dates: yyyy-mm-dd
• JQuery date picker from the Report Builder (tiki-edit_report.php) Start and End dates, seems to use this syntax for dates: dd/mm/yyyyy

Maybe this is also interfering in the filtering by dates?

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org

This bug has been demonstrated on show.tikiwiki.org

Please demonstrate your bug on show.tikiwiki.org