sori kalo tiba2 nimbrung "select * from tabel where convert(char(10),tanggal,105) = #" & format(DTPicker.value,"dd-mm-yyyy") & "#", con, itu kalo mau ambil tgl-bln-th yang sama dengan dtppicker
"select * from tabel where left(convert(char(10),tanggal,105),2) = #" & format(DTPicker.value,"dd") & "#", con, ini tanggal "select * from tabel where right(convert(char(10),tanggal,105),4) = #" & format(DTPicker.value,"yyyy") & "#", con, ini th catatan di data basenya di sempennya dengan format datetime semoga membantu sori kalo jawabannya ngacok :P martin daniel <[EMAIL PROTECTED]> wrote: Iya kebaca sih dari pertama hasilnya (contoh:24/2/07) tapi tetap ga mau match sama yang di database... saya jadi bingung... di tool tip nya sudah deteksi hasilnya tanggal kalau pk like mau... gimana ya, apa harus ubah setingan access nya atau vb nya??? thanx semuanya... beginilah lo mas, "select * from tabel where tanggal = #" & DTPicker.value & "#", con, salam lis ____________ _________ _________ _________ _________ _________ _ Never Miss an Email Stay connected with Yahoo! Mail on your mobile. Get started! http://mobile. yahoo.com/ services? promote=mail __________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 [Non-text portions of this message have been removed] --------------------------------- Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster. [Non-text portions of this message have been removed]
