This topic is locked

Advanced Search and date

6/29/2007 4:48:00 AM
PHPRunner General questions
M
mauro author

In my mysql database i've a a date column in this format YYYY/MM/GG HH.MM.SS
with advanced search if i use Dropdown boxex with datepicker i've no result with any search.
Instead if i use Simple edit box, so i can insert also HH.MM.SS there is no problem.

Ho can i resolve problem and ignore HH.MM.SS with Dropdown boxex with datepicker ?

Sergey Kornilov admin 6/29/2007

You have two options here

  1. Store date and time in to separate fields
    or
  2. Use a calculated field in your SQL query to extract the date portion and run advanced search against this calculated field.