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
Solved! Go to Solution.
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,
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):
if Isnull([absagedatum]) AND [vertrag]=1 or [vertrag]=2
then
DateTimeAdd([bewerbungseingang],2,"month")
else ''
endif
Regards,
Karolina
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