Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago
Solved

Need help correcting my Formula

Hello,   Ive got a formula that needs some work, there are a lot of IF's in   Status Schouw = IF(OR(Adressen[R.N.A.]="R40";(Adressen[R.N.A.]="R42"));"";     IF(Adressen[Civiel geplande datum]=BL...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    RvdHeijden,

    There is no issue with the last line when I make a test using sample data in my table. Could you please check that if you change the data type of Schouw datum field to Date? If this field is a text field, the above error will occur because you are comparing text values with date values in the following part. Also ensure that you have defined the data type of the Civiel geplande datum field to Date.

    Adressen[Schouw datum]<NOW()

    If the above step doesn't help, please share sample data of your table for us to test.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

RvdHeijden,

There is no issue with the last line when I make a test using sample data in my table. Could you please check that if you change the data type of Schouw datum field to Date? If this field is a text field, the above error will occur because you are comparing text values with date values in the following part. Also ensure that you have defined the data type of the Civiel geplande datum field to Date.

Adressen[Schouw datum]<NOW()

If the above step doesn't help, please share sample data of your table for us to test.

Regards,
Lydia