Nested if statements

SylviaK

Hi

Not sure why this if statement is not working. Can someone pls help?

IF
IsNull([Status Update Datetime (Latest)])
THEN "LAST STATUS UPDATE IS NULL"
ELSE IF ([Overall Rating]>3 and [Days since last status update] >40)
THEN "last update date greater than 40 days"
ELSE IF ([Overall Rating]=3 and [Days since last status update] >100)
THEN "3-rated - last update date greater than 100 days"
ELSE "last update within required timeframe"
ENDIF ENDIF Endif

many thanks, 

Sylvia

Emil_Kos

Hi @SylviaK,

Check if the data type is correct:

It looks like some of the data type isn't correct.