Comparing 2 fields in find

[Matt Leach]

I have an unusual find that i need to perform and i'm not quite sure how to perform it.

a little background. We converted our old system to filemaker rouhgly 2 months ago. The old system contained one big text field for each record that contained the notes. It also contained a date field for when the record was created.

When i did the export from the old software, for some reason on a few records it did not export all of the notes. So far i have only found a few records but am unsure if there are more.

Since 99% of the time there was a note entered the same day the record was created, what i would like to do is:

Perform a find on the text field to see if it does not contain the date field.

Hope this makes sense

[comment]

No calculations are performed during find. You need to use either a calculation field or a looping script.

[Matt Leach]

I'm pretty sure that i'm not doing the right steps but here is what i was attempting.

The date field is actually a timestamp field so here is my script:

(note that =/ stands for does not equal sign)

Set Variable [$Start; Value:Left (datefield; 10)

Enter Find Mode []

Set Field [textfield; =/ $Start]

Perform Find []

Am i way of or on the right track?

[comment]

The ≠ sign is not a valid find operator. You could find records that equal the value in the variable and omit them - but the value is going to be the SAME for ALL records. IIUC, that's not what you want.