amosch (amosch) wrote in programmerguild,
amosch
amosch
programmerguild

code help

I am attempting to pass a start and end date range to a crystal report called from visual basic 6. I have seen some code snippets online as examples, however they are not doing the trick. I keep getting an "Error in Formula"

I am gettingmy two date range variables from start and end date text boxes.

If someone could help me out, I'll have to hug ya.



strQryString = "{LndTowerData.[DATE]} >= #" & Format(txtStartDate.Text, "mm-dd-yyyy") & "# And {LndTowerData.[Date]} <= #" & Format(txtEndDate.Text, "mm-dd-yyyy") & "#"



rptLndBill.SelectionFormula = strQryString

rptLndBill.Action = 1
  • Post a new comment

    Error

    default userpic

    Your IP address will be recorded 

  • 0 comments