Date filter not working

QuestionsDate filter not working
Joel Gomes asked 3 years ago

Hi again,
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;

thank you

3 Answers
Abu Ghufran answered 3 years ago

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.

juliano gomes weber answered 3 years ago

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

Abu Ghufran answered 3 years ago

I'm closing this ticket and will be replying on email.

Your Answer

17 + 13 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?