Bisa seperti ini Set rs = con.Execute( "select * from peminjaman where tgl_pinjam = #" & DTPicker1.Value & "#)
irfan priyanto <[EMAIL PROTECTED]> wrote: ----- Original Message ---- From: David Gunawan Sugianto <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, September 7, 2005 3:08:16 PM Subject: RE: [indoprog-vb] Help me!! Mencari data menggunakan tanggal SQLnya seharusnya : Set rs = con.Execute( "select * from peminjaman where tgl_pinjam = '" & Format(DTPicker1. Value, "YYYY/MM/DD" ) & "'") -----Original Message----- From: indoprog-vb@ yahoogroups. com [mailto:indoprog-vb@ yahoogroups. com] On Behalf Of Eko Sent: 07 September 2007 13:23 To: indoprog-vb@ yahoogroups. com Subject: [indoprog-vb] Help me!! Mencari data menggunakan tanggal rekan milis yth, ketika saya mencari data berdasarkan tanggal tertentu terjadi error dengan keterangan : "Data type mismath in criteria expression" sintaks yang saya tulis seperti dibawah : Set rs = con.Execute( "select * from peminjaman where tgl_pinjam = '" & Format(DTPicker1. Value, "MM/DD/YYYY" ) & "'") atau Set rs = con.Execute( "select * from peminjaman where tgl_pinjam = '" & Format(DTPicker1. Value, "DD/MM/YYYY" ) & "'") kedua sintaks diatas sudah saya buat tetapi tetap error ------------ --------- --------- --- Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] __________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed] --------------------------------- Looking for last minute shopping deals? Find them fast with Yahoo! Search. --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed]
