Advertisement
Guest User

Untitled

a guest
Apr 21st, 2015
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. $startMonth = date('m-d', strtotime($data['start_date']));
  2. $endMonth = date('m-d', strtotime($data['end_date']));
  3.  
  4. $result = $this->ModelName->find('all',
  5. array(
  6. 'conditions' => array(
  7. 'DATE_FORMAT(HealthCareProfessional.dob, "%m-%d") >=' => $startMonth,
  8. 'DATE_FORMAT(HealthCareProfessional.dob, "%m-%d") <=' => $endMonth
  9. ),
  10. 'order' => 'DATE_FORMAT(HealthCareProfessional.dob, "%m-%d")'
  11. )
  12. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement