1 users online. Create an account or sign in to join them.Users
A for , submitted by brendo on 13 November 2009
Symphony's issue tracker has been moved to Github.
Issues are displayed here for reference only and cannot be created or edited.
A simple date filter doesn’t appear to work.
Filter on date with the hardcoded value of say 2009-11-06 fails, yet 2009-11-06 to 2009-11-06 works.
2009-11-06 to 2009-11-06
I think it might be something to do with that self::SIMPLE is 0 in field.date.php, which could be interpreted as false?
I managed to recreate this, shut my laptop, opened it again, refreshed the page… and it was resolved. I can no longer recreate the bug!
I see the problem. Using a value of 2009-11-06 yields SQL like
AND DATE_FORMAT(`t31`.value, '%Y-%m-%d') IN ('2009-11-06 00:00:00')
which is obviously a problem. The H:i:s part should be left off.
Fixed. The behaviour now is, when a date string is just Y-m-d it will be expanded to be the equivalent of Y-m-d to Y-m-d. If the H:i:s part is specified, it will be kept and the SQL will look like:
Y-m-d to Y-m-d
AND DATE_FORMAT(`t31`.value, '%Y-%m-%d %H:%i:%s') IN ('2009-11-06 12:32:43')
So, this allows for very specify date matching.
here is the commit on github
This issue is closed.
Contact the team
Symphony • Open Source XSLT CMS