Just FYI, for field API date fields that use ISO format (basically a string), the resulting expression produced by the date_views_filter_handler_simple handler is DATE_FORMAT(STR_TO_DATE(...

Posted 1 day 5 hours ago by Alejandro Cremaschi (argiepiano) on:

Filter view on date

I think storing as timestamps would be the simplest and best way. Thanks for the help!!

Posted 1 day 5 hours ago by (harpsw) on:

Filter view on date

Yes, what I suspected. The core views filter handler for dates (views_handler_filter_date) can only handle UNIX timestamp sql columns. You'll either need to extend that filter handler to...

Posted 1 day 5 hours ago by Alejandro Cremaschi (argiepiano) on:

Filter view on date

Good call on the devel...it shows the filter on the date field is looking for a unix timestamp. FYI, that value corresponds to yesterday, July 13 WHERE (( (ShowsNotices.ShowDate >=...

Posted 1 day 5 hours ago by (harpsw) on:

Filter view on date

Are you able to do some debugging? Can you output the variables in views_handler_filter_date:op_simple() ? Specifically, I would enable Devel and insert something like dpm($this->...

Posted 1 day 6 hours ago by Alejandro Cremaschi (argiepiano) on:

Filter view on date

Log in or register to add new topics