Expressions | Filter Tool | Odd and Even Filtering

[JBO]

I am building an expression in the Filter tool to isolate data that has an odd number in a particular field. I can't find a function for identifying odd and even values. Is there one?

Thanks.

[adm510 · Accepted solution]

Mod([Field1], 2)

Use the modulus function, if it returns 0 the number is even, if it returns 1 the number is odd

2 % 2 = 0

3 % 2 = 1

4 % 2 = 0

...

[JBO]

Thank you!