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,

What error do you receive?

[Emil_Kos]

Hi @SylviaK,

I have replicated this and it looks like it isn't a matter of error.

It will be hard to help you if you will not share more information about why it isn't working for you. 

[SylviaK]

I get the above error and my beginning IF is underlined red

[Emil_Kos · Accepted solution]

Hi @SylviaK,

Check if the data type is correct:

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

[SylviaK]

brilliant. that worked. many thanks