Question CR select range of date?

[black zero]

on Crystalreportviewer? This is my code, and is working good to display transactions on a certain date, that's picked on Tgl_awal (datepicker). However, I'd like to pick 'range of date' e/g 1 jan until 31 jan.

Private Sub tampilkan_laporan_rate()
        CrystalReportViewer1.ReportSource = Module1.tampilkan_Laporan("RptRate")
        CrystalReportViewer1.SelectionFormula = "{BIAYA.TANGGAL}= CDateTime('" & Tgl_awal.Text & "')"

    End Sub

Help me, please?

 

[Pete (BSC)]

Have you tried:
CrystalReportViewer1.SelectionFormula = "{BIAYA.TANGGAL}>= CDateTime('" & Tgl_awal.Text & "')" AND BIAYA.TANGGAL}<= CDateTime('" & {Tgl_awal2.Text & "')"

 

[black zero]

Have you tried:
CrystalReportViewer1.SelectionFormula = "{BIAYA.TANGGAL}>= CDateTime('" & Tgl_awal.Text & "')" AND BIAYA.TANGGAL}<= CDateTime('" & {Tgl_awal2.Text & "')"

Lol so nice. Thanks alot.