Filter reports by date

Hi,
Im using DataEnvironment to create reports. Ive used command named DailySales_Grouping which is grouped by Bill Number. The following is the code to filter data is placed in the cmdShowReport click event. The problem is that it displays error saying Failed getting rowset from the current datasource. Could someone help me with this?

Code:

---

  DataEnvironment1.rsDailySales_Grouping.Filter = "Date = " & frmInvoice.lblDate.Caption & ""
  rptDailySales.Refresh
  If rptDailySales.Visible = False Then rptDailySales.Show

---

If your database is Access then could you try this?

Code:

---

DataEnvironment1.rsDailySales_Grouping.Filter = "Date = #" & frmInvoice.lblDate.Caption & "#"

---

No its still not working.

Does it still raise the error?

Yes it gives the same error.

See what happens when you try this,

Code:

---

msgbox frmInvoice.lblDate.Caption

---

It looks like the code in post 2 should work.