Crystal formula error

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.

Try using CSTR function

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


HTH,
Jyothi

Hi,


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