SELECT
*
FROM
somedatabase a
WHERE
MONTH(a.tanggal)='some month'

@old_shutherhand: kayanya mm/dd/yy, diparsing dulu deh,ambil mm nya doang terus masukin di query copy(date,1,2), cmiiw

case combobox_bulan.itemindex of
0: query:='select  from table1 where extract(MONTH FROM table1 HWERE EXTRACT(MONTH FROM tanggal_trx)=1';
1: query:='select   from table1 where extract(MONTH FROM table1 HWERE EXTRACT(MONTH FROM tanggal_trx)=2';
.
.
11: query:='select  from table1 where extract(MONTH FROM table1 HWERE EXTRACT(MONTH FROM tanggal_trx)=12';
end;

“SELECT   FROM table WHERE MONTH(tanggal_trx)=1 AND YEAR(tanggal_trx)=2008“