Record selection formula editor error (1 Viewer)

[dashing]

hello I'm trying to generate crystal report based on the two dates selected by the user ...

the selection formula editor gives me the error "a string is required" when I want
to save and close my formula , can any1 help me whts wrong with my formula shown below ,

{records.entrance_date} >= {?entrance_date} and {records.entrance_date} <= {?entrance_date2}

both ?entrance_date and ?entrance_date2 are of date data type



thanks

 

[kevlray]

Is {records.entrance_date} a date or a string in the DB?

 

[Mohanbabu.Pandari]

try this.. This should work

{records.entrance_date} >= cDate({?entrance_date}) and {records.entrance_date} <= cDate({?entrance_date2})


If you are using Single date range Paramater then use the following
{records.entrance_date} >= Minimum({?entrance_date}) and {records.entrance_date} <= Maximum({?entrance_date})

Thanks
Mohanbabu Pandari