Conditional formatting issues - InfoPath Dev
in

InfoPath Dev

Conditional formatting issues

Last post 02-03-2013 07:04 PM by marktienzo. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-07-2012 10:22 AM

    Conditional formatting issues

    Hello there Wizards and Gurus!

     

    THis is my issue. I have a project management form. I have 3 fields that my question concerns. Original End Date(OrigED), Adjusted End Date(AdjED) and Rag Status(RAG) which has values of red amber green and closed. (R A G C), The functionality I am ultimately looking for is if OrigED and AdjED have both passed, then RAG Status must equal EITHER C or R. I can make it work when RAG is equal to c, or I can make it work when RAG is equal to R, but not when it is EITHER C or R. Is this some funky infopath rule? This is what I'm working with now in the data vaidation window:

    If OrigED is less than or equal to today() AND

    AdjED is less than or equal totoday() AND

    RAG is not equal to C

    I would think all I should have to add is another OR statement:

    Rag is not equal to R

     But this doesn't work. any ideas?

  • 02-03-2013 07:04 PM In reply to

    Re: Conditional formatting issues

     Good day surly0k,

    I noticed that you used is not equal to and on your question you like it to be equal to R or C.  Try using RAG is equal to C OR RAG is equal to R, if this is what your aiming for.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.