Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass Dates to CrystalXI from VB6

Status
Not open for further replies.

mgason

Technical User
Feb 6, 2003
158
AU
Hi,
how do I do a selection statement in VB with a date range for Crystal?
I have StartDateBox.value and EndDateBox.value, 2 date time values in VB6.
I need to select based on those values
basicly
Code:
report1.RecordSelectionFormula = "{MyTable.tstamp}=> '" & StartDateBox.value & "' AND {MyTable.tstamp}<= '" & EndDateBox.value & "'"

I know I need to format the date values etc, I just can not get it right.

thanks for any help
mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top