{?Start Date} >={Event_Cath.Date_of_Cath} And
{?End Date} <= {Event_Cath.Date_of_Cath} And
{?Procedure Name} like '%{Cath_Extension.IR_ProcedureType}%'

Dates are fine but the procedure name is problematic. What am I doing wrong? Any help would be greatly appreciated. thanks

 

{Event_Cath.Date_of_Cath} in {?Start Date} to {?End Date}
 And
InStr (1,{Cath_Extension.IR_ProcedureType}, {?Procedure Name}) > 0

 

And it still only takes discrete values so if it is not an exact match, then it does not return any rows. When I added the ',1' after procedure name, an error message came up telling me there were too many arguments. I also tried the like clause and it wouldnt take my parameter.

break this down to figure out what is going on...Create a formula as "TestInstring"

place it on your details section.

It should be TRUE whenever the text from your paramter falls inside your IRPRocType field. If not are there recurring circumstances that you think it should be doesn't that tells you why?

This has to be an exact match (not case sensitive because of the ,1 I added)

Example

"Biopsy" will match  "In a biopsy" but not "in a bi-opsy"

or

"Biopsy    " will not match "biopsy" becasue of the spaces (hence trying the trim)

 

Edit : you can use lcase() to deal with your case issue in you other post...

lcase(field) like lcase(field)