Performing a find for two dates that are differnent

[James Gill]

Pretty simple. I want to perform a search across two date fields for for any instance where the two fields do not have the same date but I'm not sure how to do this...

[bcooney]

You could create a flag field that equals 1 if the two fields are equal. Just find for 1's in the flag field.

I'm sorry James, you want the opposite. So, reverse the logic. Flag = if (field1<>field2); 1; "" ) Now, find for the 1's.

Edited August 10, 2010 by Guest