Parameter problem

[elead]

I am sending in 2 parameters to a report that should be picked up as date but the report is squawking for a string in lieu of date, is there a setting somewhere in CR that I missed somewhere

The dbfield type is MSSQL Datetime

The parameters are

{?DateStart}--Date
{?DateEnd}--Date

thanks

 

[synapsevampire]

Sending parameters from what, and in what format?

Share the code that you're using, and state the specific error rather than a barnyard simile

I'd double check the parms to make sure that they are of type date too.

-k

 

[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

 

[lyanch]

Where does the cursor appear at when you get the message? It could as easily be the {?AccountNo} that requires a string..

Lisa

 

[akabatman2]

Try this:

{results.LCDATE}
In Date({?StartDate}) To Date({?EndDate})