Formula not working

[Kanu_Haselhorst]

Hi,

I have following formula:

IF(
    OR(
        {Austritt-Datum} <= today(), 
        {Verstorben} <= today()
    ), 
    "Nein", 
    "Ja"
)

For one data entry {Austritt-Datum} is 31.12.2022, so in the past. The output of the above formula is still “Ja” , but should be “Nein”.

Can someone help out?

[rdb]

Works well here:

This is my formula:

[Kanu_Haselhorst]

Thanks! I found the issue. When the field “Austritt-Datum” is empty, then the formula returns “Ja” even though the field “Verstorben” is in the past. So both fields need to have an input value for it to work.

Is there a way to fix this?

[cdb]

You can encapsulate multiple ifs together:

if(a = a, "same value", if(a = b, "another value", "anything else"))

I am sure you will find a solution.