October 28, 201015 yr 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
October 28, 201015 yr No calculations are performed during find. You need to use either a calculation field or a looping script.
October 28, 201015 yr Author 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?
October 28, 201015 yr 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.
Create an account or sign in to comment