Criteria Not In Between Date How To

[aekkapun (Aekkapuncs)]

Help Me .I want Select Data Not In Between date

In Between Date Is Work

    $criteria = new CDbCriteria();


    $criteria->addBetweenCondition('create_date', $startDate, $endDate);

Not Between Date Not Work!!

    [b]

$criteria->condition = ‘create_date < :startDate AND create_date > :endDate’;

        $criteria->params = array(':startDate' => $startDate, ':endDate' => $endDate);

[/b]

[Bizley]

$criteria->addCondition('create_date < :startDate AND create_date > :endDate');

$criteria->params = array(':startDate' => $startDate, ':endDate' => $endDate);

If $startDate < $endDate this condition is never met. It should be

$criteria->addCondition('create_date < :startDate OR create_date > :endDate');

$criteria->params = array(':startDate' => $startDate, ':endDate' => $endDate);

[aekkapun (Aekkapuncs)]

$criteria->addCondition('create_date < :startDate AND create_date > :endDate');

$criteria->params = array(':startDate' => $startDate, ':endDate' => $endDate);

If $startDate < $endDate this condition is never met. It should be

$criteria->addCondition('create_date < :startDate OR create_date > :endDate');

$criteria->params = array(':startDate' => $startDate, ':endDate' => $endDate);

Thank You Very Much Use OR