Drupal Between query

$query = db_select('members', 'n')->fields('n');

 $query->condition('date_of_registration', array($search_start_date, $search_end_date), 'BETWEEN');

 $result = $query->execute();

 while($record = $result->fetchAssoc()) {

}