Record selection formula editor error

[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

[jggtz]

And what about ---> {records.entrance_date} ? Is it date data type too?

JG

[dashing]

yes thts also of date data type

[jade1977]

Try

{records.entrance_date} in {?entrance_date} to {?entrance_date2}

[dashing]

hello my problem is solved by selecting the data type of the variables ?entrance_date and ?entrance_date2 as 'string' .............

[jggtz]

Then your table field {records.entrance_date} is not of date data type