I have a strange problem with script steps and find. I want to search to dates that

have a test with Date&"..."&Date

Use Insert Calculated Result instead of Set Field.

Show all records

Enter Find mode []

Insert Calculated Result["Date","searchdate"]

Perform find [Replace found set]

Another way to find a range of dates is to enter the find criteria as:

FirstDate...LastDate

So the calc for the searchdate field would be:

FirstDate&"..."&LastDate

Thanks for your help, but the problem still remain. I changed to your suggested calculation and set field in the script and FMP returns no records.

The new calculation feild:

Firstdate&..."&lastdate

If I change back to

Avoid using paste.

Make Case statement field returning 0 or 1 according to the calculation Case(Date > global1 and Date< global2; 1; 0) and make a search on all records with 1 in the field.

Set the Perform Find to NOT replace find request.