named_scope :for_date, lambda { |date|
  from = DateTime.parse "#{date} 12:00 AM"
  to = DateTime.parse "#{date} 11:59:59 PM"
  {
    :conditions => ["datetime BETWEEN ? AND ?", from, to]
  }
}


#sample use
tours = Tour.for_date(Date.today).all