Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#3688 (ok 4.0) Can not use LIKE statement for date fields

3.5.2
fixed
Usability (35)
1
2013-06-11
2012-10-01
RST
No

When using DATE or DATETIME fields in the tbl_select.php (the 'Search' option), it is impossible to enter values like '%' in the search field. This renders the usage of LIKE kinda useless ;-).

I confirmed that this has to do with the jQuery datepicker that is being used. When I disable the timepicker script, I can use these values again.

Discussion

    • assigned_to: nobody --> chanaka777
     
    • priority: 5 --> 1
    • summary: Can not use LIKE statement for date fields in tbl_select.php --> (ok 4.0) Can not use LIKE statement for date fields
    • status: open --> open-fixed
     
  • This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Marc Delisle
    Marc Delisle
    2013-05-03

    • Status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed