If statement is not working when I add the last value

Hi all,

I am struggling to find what is the problem in that simple IF statement and I would appreciate to have your help:

IF [Warranty expiration]>2 AND [Warranty expiration]<7 THEN "Wave 1"
ELSEIF [Warranty expiration]>6 AND [Warranty expiration]<10
THEN "Wave 2"
ELSE "Wave 3"
ENDIF

The statement it seems fine until I am entering the last value "Wave 3" and specifically the last ".

The Warranty expiration is an Int32 field that has been created by the DateTimeMonth([Warranty expiration]) expression and saves the number of the month.

There are no Nulls is that.

The "Wave x" is save to a new column as string.

Thanks in advance,

Kostas

Output

Accepted answers

estherb47

Hi @Kostas

Try changing the variable in your formula to [Month of expiration], which is the Int field from the formula that determines the month.

Cheers!

Esther

All comments

fmvizcaino

Hi @Kostas ,

The formula is working as it should when [Warranty expiration] is an int number, if it is a string, it does exactly what you are relating. Maybe you forgot to update the data type in your formula DateTimeMonth([Warranty expiration])

Best,

Fernando Vizcaino

2020-09-11 If statement is not working when I add the last value.yxmd

estherb47

Hi @Kostas

I'd first check the data type of the field [Warranty expiration]. Although the formula does result in an Int, the formula tool will save it as text unless you specify the data type should be Int. I make that error all of the time, forgetting to set data types.

Is the problem that the formula itself is failing everywhere, or only when the data in Warranty Expiration doesn't fall into the criteria for Wave 1 or Wave 2? Seeing the actual errors can help us troubleshoot what's going on

Cheers!

Esther

Kostas

Thank you both for the fast reply.

It seems that it is a data type issue since the formula is working for you Fernado. I am getting the error that you are getting when it is changing to string:

Is there somewhere else that I need to set the data type for Warranty expiration field?

/Kostas

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703