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
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
