coba bro standard SQL SERVER 2000 formatnya : mm/dd/yyyy
2008/8/19 agus_prambono <[EMAIL PROTECTED]>
> berikut adalah source code dimana saya menggunakan datepicker untuk
> mengambil tanggal sebagai parameter.
>
> Report.RecordSelectionFormula = "{lap_penj_bruto.tanggal}>='" &
> Format(FrmLapPenjualan.DTPicker1.Value, "yyyy-mm-dd") & "' and
> {lap_penj_bruto.tanggal}<='" & Format(FrmLapPenjualan.DTPicker2.Value,
> "yyyy-mm-dd") & "'"
>
> Sedangkan pada database saya tanggalnya tipe datetime (sqlserver 2000).
> tapi ketika di run selalu muncul pesan error dari VB6:
>
> Run-time error'-2147191747 (8004743d)':
> A date-time is required here.
>
> padahal saya telah cek dengan immediate window hasil format tanggalnya
> sudah benar. Adakah dari teman2 dan senior yang dapat membantu saya.
>
> Terima kasih
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
