SQL Conditional Field Query

Cakphp::SQL Queries

<?php 
    $conditionalField 
                = '(IF( User.joined_date IS NOT NULL, 
                        DATE_FORMAT(User.joined_date, "%d-%m"), 
                        DATE_FORMAT(User.created, "%d-%m")))';
            $conditionalField2 
                = '(IF( User.joined_date IS NOT NULL, 
                        DATE_FORMAT(User.joined_date, "%Y"), 
                        DATE_FORMAT(User.created, "%Y")))';
            $this->User->recursive = -1;
            $flag = true;
            $options['conditions'] = array(
                                      $conditionalField      => $presentDate,
                                      $conditionalField2.' <'=> date('Y'),
                                      'User.company_id'      => AuthComponent::user('company_id'),
                                      'User.account_status'  => $userInstance::ACTIVE,
                                     );
?>