Coba code berikut :
Set rs = cn.Execute("insert into test values ('" &
format(dtpicker1.value,"MM/DD/YYYY") & "')")
Thank's
----- Original Message -----
From: Eko
To: [email protected]
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]