Two IF statements in one formula

Hi,

I am trying to get an output of all the cases who were opened for more than 60 days, but is still currently opened and not closed.

IIF(DateTimeDiff([Cased Closed],[Cased Opened],'day') >=60, 'Yes','No')

This formula works to give me 'Yes' for cases that were opened for 60 days, and 'No' if opened for less than 60 days. However, I want the include the AND cases that are still currently opened.

So the 'Yes' would only show if the cases have been opened for 60 days and is still open.

example:

Any help is appreciated!

Date Time

Accepted answers

gabrielvilella

You need a new condition:

IF IsNull([Cased Closed])
THEN 'Yes'
ELSEIF DateTimeDiff([Cased Closed],[Cased Opened],'day') >=60 AND [Status] != 'Closed'
THEN 'Yes'
ELSE 'No'
ENDIF

All comments

gabrielvilella

You can write as:

IF DateTimeDiff([Cased Closed],[Cased Opened],'day') >=60 AND [Status] = 'In Progress'

THEN 'Yes'

ELSE 'No'

ENDIF

mzsweetumz

This works, however in my particular case -- some of the cases have a Null value for 'Case Closed' as they're still open.

That formula didn't work for this.

IF DateTimeDiff([Cased Closed],[Cased Opened],'day') >=60 AND [Status] != 'Closed'

THEN 'Yes'
ELSE 'No'

ENDIF

example:

MarqueeCrew

@mzsweetumz ,

I'll provide you with a way to use your IIF() logic:

IIF(DateTimeDiff([Cased Closed],[Cased Opened],'day') >=60 OR [Status] != "Closed", 'Yes','No')

When cased closed is empty or when cased open is in the future, you should handle these conditions better. Just a thought.

Cheers,

Mark

gabrielvilella

You need a new condition:

IF IsNull([Cased Closed])
THEN 'Yes'
ELSEIF DateTimeDiff([Cased Closed],[Cased Opened],'day') >=60 AND [Status] != 'Closed'
THEN 'Yes'
ELSE 'No'
ENDIF

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703