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
Subscribe
  • Post a new comment

    Error

    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 0 comments