Passing date parameter from VB

[smalley]

I am using CR 8.0.1 and VB 6. I have created a parameter in my report of type date/time. I want to pass a date from a variable of type date. If I pass a literal it works fine but I cannot use the variable. I have tried to pass a date and a string. The format that I am passing is: yyyy-mm-dd. I get a type mismatch error.
Thanks for the help.

 

[balves]

I believe that you should pass it as a string from VB, define it as Date or Date/Time as the parameter in Crystal.

If you're using a Date variable in VB, use CStr() to convert it.

 

[smalley]

I have tried to pass it as a string and a date and neither work.