----- 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]
