formula

[jhermiz]

Im trying to open a crystal report in vb.

Im using the RecordSelection formula propoerty of the report object.

In the criteria i have the following:

strFormula = strFormula & " AND {vwProposalsByOriginator.OpenDate} BETWEEN #" & CDate(frmReports.txtFrom.Text) & "# AND #" & CDate(frmReports.txtTo.Text) & "#"

But its not working...have I messed something up...

strForumla originally has the following

vwProposalsByOriginator.Originator='jblow'

[jhermiz]

Nevermind

crystal doesnt like between :-d

strFormula = "{vwProposalsByOriginator.OpenDate} >=#" & CDate(frmReports.txtFrom.Text) & "# AND {vwProposalsByOriginator.OpenDate} <=#" & CDate(frmReports.txtTo.Text) & "#"