arg_format = 'Y'; //$this->formula = views_date_sql_extract('YEAR', "***table***.$this->real_field"); //EXTRACT(YEAR FROM event.event_start) $this->formula = "EXTRACT(YEAR FROM ***table***.$this->real_field)"; } } /* SELECT node.nid AS nid FROM node node LEFT JOIN event event ON node.nid = event.nid WHERE (node.type in ('event')) AND (EXTRACT (YEAR FROM event.event_start) = '2010') */