crystal reports datetime problem (resolved)

[tr0n]

i've got a crystal report that feeds off a stored procedure, that requires a datetime parameter. but when i pass a date in to the report from VB, i get a type mismatch error. this is the code i have to pass the date in:

pReport.ParameterFields(i).AddCurrentValue CDate(strParams(i - 1)) 'strParams(i - 1) is "01/01/01"

i thought this might be because crystal wants a time as well, so i tried this:

pReport.ParameterFields(i).AddCurrentValue Format(strParams(i - 1), "dd/mm/yy hh:mm:ss")

which still didn't work. then i tried just using the Now() function, and didn't get an error (although the report obviously returned no results).

has anyone overcome this problem?

[swatty]

The format seems right;
Did you try to fetch the result of
Format(strParams(i - 1), "dd/mm/yy hh:mm:ss")

could be it isn't what you needed.

[tr0n]

yup, Format(strParams(i - 1), "dd/mm/yy hh:mm:ss") returned "01/01/01 00:00:00".

[wrack]

how about changing it to text I mean CStr function...

give it a go and I hope it should work...

[tr0n]

nope i've even tried using CVar().

for every other data type i'm passing to a report, i'm using CLng for numbers, CStr for strings, CDate for dates, etc., but for some reason it doesn't wanna know when it comes to a DateTime.

[tr0n]

ah, i think i found a solution. i just went to File -> Report Options and chose "Convert Date-Time Field: To Date".

[swatty]

Did it work ??

[tr0n]

yep

[vsusi]

That was a good solution. I had the same problem too.

But the only problem may be if you want to display a date with time. In that case you can try the below code.

I went to my stored procedure and changed my date parameter to char(11) and converted that parameter to date inside sto proc. This works.

Any comments or suggestions?

[tr0n]

yeah, that seems like a pretty good solution too, if you need to have both date and time.