3 Replies Latest reply on Jun 13, 2009 6:42 AM by RickWhitelaw

# The word "not"

### Title

The word "not"

### Post

While checking out demos and such I've come across the word "not" in formulae. Is "not" the same as Boolean "0" ? For example, is:

Let([VAR1 = Mod(Get(CalculationRepetitionNumber);5)=0];VAR1)

the same as:

Let([VAR1 = not Mod(Get(CalculationRepetitionNumber);5)];VAR1)

It seems "not" was a once-used word that still works but is no longer documented in Filemaker.

RW

• ###### 1. Re: The word "not"

Not exactly. NOT is a logical operator such as AND, OR, and XOR.

It does return a boolean value but it returns a True for a False statement and Viceaversa.

IOW:

( 1 = 1 ) =1 (True)

not ( 1 = 1 ) = 0 (False)

not not ( 1 = 1 ) = 1 (True)

Here is the info on it.

http://www.filemaker.com/help/html/non_toc.46.45.html#1029464

• ###### 2. Re: The word "not"

Hi Rick

not exactly...

the "not" is a logical operator ( result boolean ) so:

not 5 = 0
not 1 = 0
not 0 = 1

not Self [ with Self an empty field ] = 1

Edit: Mr Vodka was quicker !

• ###### 3. Re: The word "not"

Thanks you guys!

Of course! I've used "not" plenty of times but I never use it at the beginning of an expression. There's obviously no reason not to. Very useful actually.

RW