i need to use filter on a date type column, if i try to do a search or a filter it goes empty, any solution?
$g->select_command = "SELECT *, date_format(INVOICE_DATE, '%d-%m-%Y') from angola_reg where place2 like '".$_SESSION['place2']."' and INVOICE_N != ''";
$col = array();
$col["title"] = "Invoice date";
$col["name"] = "INVOICE_DATE";
$col["dbname"] = "date_format(INVOICE_DATE, '%d-%m-%Y')";
$col["editable"] = FALSE;
$col["width"] = "50";
$col["formatter"] = "date";
$col["search"] = true;
$col["export"] = true;
$cols = $col;
As you have set "dbname" to "date_format(INVOICE_DATE, '%d-%m-%Y')" … the search input should be in format dd-mm-yyyy.
Please explain what input are you giving.
Screenshot would help.
im working with date picker, when i select a date, he gives blank grid…
even without datepicker if i insert a date doesnt filter.
i will send a screenshot by email
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?