Invalid type in operator

alexg1

Hello,

As noted above, I've received an "Invalid type in operator" error for the following code:

IF findstring([DEPART/ARRIVE],substring([DEPART/ARRIVE],1,6))=substring([Row-1:DEPART/ARRIVE],1,6)

AND [DATE]=[Row-1:DATE]

AND [Stop?] = "1"

THEN [Stop?] = "0"

ELSE [Stop?] = "1"

ENDIF

Some quick searching says this tends to occur when there is a mismatch between string and numerical datatypes, hence the quotes around 1 and 0, but removing the quotes and using a Select tool to change them to INT16 does not appear to resolve the issue. I'm sure I'm missing something small, but any help would be appreciated.

JoeS

In which case, do you need the find string part?

Or can you just check those 6 characters are the same?

IF substring([DEPART/ARRIVE],1,6))=substring([Row-1:DEPART/ARRIVE],1,6)
AND [DATE]=[Row-1:DATE]
AND [Stop?] = "1"
THEN [Stop?] = "0"
ELSE [Stop?] = "1"
ENDIF