Crystal formula error

[vpriyanka]

I have this Formula, I am changing the database for the report.

Old Formula
{quote.lifecycle_status} in ["LOSTQUOTE", "QUOTE"] and
{quote.date_effective} = {?Quote Eff Dates}


New Formula Field is a NVARCHAR
{quote.lifecycle_status} in ["LOSTQUOTE", "QUOTE"] and
{quote.date_eff_ccyymm} = {?Quote Eff Dates}

I am getting String Required here at {?Quote Eff Dates}

Please help.

[Jyo4981]

Try using CSTR function

{quote.date_eff_ccyymm} = CSTR({?Quote Eff Dates})


HTH,
Jyothi

[K.Babu]

Hi,


Use ToText({?Quote Eff Dates}) to convert string datatype in crystal report formula.