Coba code berikut : Set rs = cn.Execute("insert into test values ('" & format(dtpicker1.value,"MM/DD/YYYY") & "')")
Thank's ----- Original Message ----- From: Eko To: indoprog-vb@yahoogroups.com Sent: Wednesday, June 27, 2007 11:06 AM Subject: [indoprog-vb] Help! Cara Menimpan Tanggal gimana ya cara menyimpan tanggal ke dalam SQL Server. coding saya tulis dalam vb dengan sintaks : Set rs = cn.Execute("insert into test values (" & dtpicker1.value& ")") dtpicker saya isi dengan tanggal 26/01/2007, tapi data yang tersimpan dalam database menjadi 01/01/1900. tolong dunk sintaks yang benar seperti apa ? --------------------------------- Shape Yahoo! in your own image. Join our Network Research Panel today! [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]