I need a formula for the expression which has the rule the column must have a date (in below format) or TBC. It is text column.
I have the formula in the image but this is not working.
Solved! Go to Solution.
you are setting the enabled property of the field there? did you want validation?
Use validations rules instead it.
I can't get it to work?
When I type anything in the column it accepts it.
I noticed that I put . instead or , in the above. Amending it to , still did the same.
I think your validation rule is close to correct. I have noticed that from the outer layer it should always seem like only one statement, i.e. and(or(equals(a,b),"abc"),"def")
In your example you are excluding the last bit not(equals... with a bracket to many behind isdate({Self})))
and(not(isdate({self})),not(equals({self},"TBC")))
So maybe just a bracket to many. Let me know if this worked.
It worked - Many thanks All.