Question CR select range of date?

black zero

Well-known member
Joined
Jan 15, 2009
Messages
53
Programming Experience
Beginner
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.

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

    End Sub

Help me, please? :confused:
 

Pete (BSC)

Well-known member
Joined
Oct 19, 2007
Messages
89
Programming Experience
10+
Have you tried:
CrystalReportViewer1.SelectionFormula = "{BIAYA.TANGGAL}>= CDateTime('" & Tgl_awal.Text & "')" AND BIAYA.TANGGAL}<= CDateTime('" & {Tgl_awal2.Text & "')"
 
Top Bottom