Matching Dates

[eluser]Sanjay Sarvaiya[/eluser]
in where cause compare date format Y-m-d.
bellowed code is not tested just for your reference.

Code:

function count_date_events($date_is)
    {
  
  return  $this->db
      ->select("DATE_FORMAT(`event_date_begin`,'%Y-%m-%d') AS event_date_begin", FALSE)
            ->where(DATE_FORMAT(`event_date_begin`,'%Y-%m-%d'), $date_is)
      ->from('eventcal')
                  ->count_all_results();
    }