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?