Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago
Solved

What am I doing wrong ?!

Why wont this formula work ?   I need to change the format of a date value IF a certain value is not R40 or R41  
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi, it looks to me like the syntax for OR() is incorrect. the OR function takes two logicals as the inputs so it should look more like

    IF( OR( ADDRESSEN[...] = "R41", ADDRESSEN[...] = "R40"), result if true, result if false)

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi, it looks to me like the syntax for OR() is incorrect. the OR function takes two logicals as the inputs so it should look more like

IF( OR( ADDRESSEN[...] = "R41", ADDRESSEN[...] = "R40"), result if true, result if false)

  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    9 years ago

    Anonymous

    you were right, i had to tweak the formula a bit but this one did the trick.

     

    Civiel geplande datum = IF(OR(Adressen[R.N.A.]="R41";(Adressen[R.N.A.]="R40"));"";(Format(Adressen[civiel begin];"DD-MM-YYYY")))