vb6, Crystal7, pass a date range to a parameter?

[mgason]

Hi,
I need to pass in the values for a date range in a Crystal7 report.

The Parameter (TimeFrame) is set to value date and type range in Crystal. It works fine in the report asking for start and end dates.

The dates are passed from 2 fields in VB6

TimeFrame is Parameter(0) its the only one

I tried this and variations

ShiftReport.ParameterFields(0) = "TimeFrame;" & Format(StartDateBox, "mm/dd/yyyy") & "," & Format(EndDateBox, "mm/dd/yyyy") & ";False"

am I even close?
thanks mark

 

[mgason]

OK I found an answer on my own, for anyone who should run into this problem on an old system read crystal knowledge base article c2006899 for passing both date and time

http://technicalsupport.businessobjects.com/Publishing/271/c2006899_f.html

for passing just date a simpler solution is article c2003724

http://technicalsupport.businessobjects.com/Publishing/827/c2003724_f.html