Confused with searching

[Alex_ND]

I'm trying to script a search that finds records updated by someone other than the record owner (salesperson in my case).

I have a global variable called last logout that does a timestamp when the user logs out of filemaker. So the basic search I want to do is Find records where dateupdated > gLastLogout AND salesperson does not equal currentuser.

But I can't figure out how to do a find using both an "is" and a "is not" if you know what I mean.

[Our Town]

This may not be the best way to do this but it has worked for me in the past. Create a field that is X's if salesperson does not equal currentuser.

CheckUser (Calcualtion, text) If(Salesperson<>Currentuser;"X";"")

That way you can do the find and X that field and set that other date field to check the logon date. Your find will check both.

I hope this makes sense.