Date Parameter Error

[elead]

I am receiving an error message from crystal saying "a string is required here when I try to run my report"
Datebase is MSSQL
any ideas??

thanks

Here is the code
{results.accountno} = {?AccountNo} and
{results.termcd} = "SA" and
{results.LCDATE} in {?ReportStart} to {?ReportStop}

results.LCDATE is Datetime Field

{?ReportStart}--Date
{?ReportStop}--Date

 

[cmpgeek]

try this:

{results.accountno} = {?AccountNo} and
{results.termcd} = "SA" and
datevalue({results.LCDATE}) in {?ReportStart} to {?ReportStop}


good luck...




*forever a student - rarely a teacher*

cheysmommy

"I keep hitting 'escape' but I'm still here..."

 

[synapsevampire]

Isolate the fields to determine which is the offending one.

It's probably either of these, providing you are certain about the datetime field:

{results.accountno} = {?AccountNo} and
{results.termcd} = "SA"

Perhaps you made the {?aAccountno} a numeric and the field is a string?

Right click any field and select browse data to learn it's type and to see example data.

-k