Struggle with brackets

CiaoPaola

hi,

this is an IF formula with 2 conditions to be checked

I created a field to receive the result : CloseDate

absagedatum and bewerbungseingang are Date fields. Lets call them Date1 and Date2

vertrag is a field containing 3 values (1, 2 or 3) or null values.

it says:

if Date1 is null and vertrag is 1 or 2

then add 2 months to Date2

or CloseDate remains empty

If Isnull([absagedatum] AND [vertrag] ='1' OR '2')
then DateTimeAdd([bewerbungseingang],2,"months")
else ''
endif

Can't find out where is the syntax error.

Thank you

Paola

Preparation

Accepted answers

CiaoPaola

Hi Karolina

Hi Messi

thank you for your help

Karolina, your formula is working fine.

Yours, Messi, do not but I won't be able to tell you why.

However thank you both for your help

have a nice day

Paola

All comments

messi007

@CiaoPaola,

Please see below

if isnull([Date1]) and [vertrag] in ( "1","2")
then DateTimeAdd([Date2],2,"Month") 
elseIf Isnull([absagedatum]) AND [vertrag] in ('1' OR '2')
then DateTimeAdd([bewerbungseingang],2,"months")
else ''
endif

Let me know if it works or not.

Regards,

KarolinaRoza

hi @CiaoPaola ,

please try with that formula (it depends what type of data column you have, if [vertrag] is string then you need to apply "", if it is Byte then just number is enough):