gw kasih tahu cara yang termudah
select * from tblsend where format(tanggal,'mm/yyyy')
='" & bln_thn & "'
--- Purwedi Kurniawan <[EMAIL PROTECTED]>
wrote:
> select * from tblsend where day(tanggal) = " & tgl &
> " and month(tanggal) =
> " & bulan
> rgds
> [wwn]
>
> On 9/16/05, Dedy <[EMAIL PROTECTED]> wrote:
> >
> > Guys.....,
> > scipt ini dibawah ini Filter record berdasarkan
> Tanggal
> >
> > cn.BeginTrans
> > qsql = "Select * from tblsend where Tanggal
> BetWeen #" &
> > Format(txtTgl,"mm-dd-yyyy") & "# And #" &
> Format(txtTgl2, "mm-dd-yyyy")
> > & "#"
> > cn.Execute qsql
> > cn.CommitTrans
> >
> > Kalau Hanya Berdasarkan Hari dan Bulannya saja
> bagaimana ya scriptnya....?
> >
> >
> >
> > Untuk keluar dari millis ini, kirim email kosong
> ke:
> > [EMAIL PROTECTED]
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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/
