On Friday 10 February 2006 22:01, Nast Stsn wrote:
> ........................(dihapus)
> Set rsDtSurat = New ADODB.Recordset
> rsDtSurat.Open "select * from tblsurat where tglsurat >=#" &
> DTPicker2.Value & "# and tglsurat <=#" & DTPicker3.Value & "#", DtSurat,
> adOpenDynamic, adLockOptimistic
>..................(dihapus lagi)
> Bagaimana caranya agar data tampil dengan setingan tanggal dd/MM/yy dan
> dengan menggunakan obyek DTPicker?
=My Reply=
Setau saya (kalo pengetahuan saya tidak salah), di database data tetap
tersimpan dalam format MM/DD/YYYY. Sehingga ketika kita query pake format
tsb, data bisa ditampilkan.
Supaya ditampilan bisa tampil dalam format DD/MM/YYYY, manipulasi di sisi
tampilannya saja.
Contohnya, DTPicker tetap dikasih format DD/MM/YYYY ditampilannya, tapi pas
ketika dikirim ke database, kita format menjadi MM/DD/YYYY.
Set rsDtSurat = New ADODB.Recordset
rsDtSurat.Open "select * from tblsurat where tglsurat >=#" &
format(DTPicker2.Value, "mm/dd/yyyy") & "# and tglsurat <=#" &
format(DTPicker3.Value,"mm/dd/yyyy") & "#", DtSurat,
adOpenDynamic, adLockOptimistic
Semoga membantu. ^^
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
