Just had trouble posting a fx

[Expiry]

I just posted some formula for someone.

=(AND(E59="",D59<TODAY()))

But it kept being showed as

=(AND(E59="",D59

But when I clicked edit, it had the full formula again. Does anyone know why?

 

[Joe4]

I am guessing that you have greater than or less than signs in your formula. What happens is those are confused for HTML code. There are a few ways around that.

1. Enclose your formula in Code tags (highlight the formula and click on the pound symbol icon in the text editor).

2. Place a single space before and after your greater than/less than signs

3. Disable HTML code posting (I think this may be a personal setting under the User CP menu, not really sure exactly where it is).

 

[Peter_SSs]

More often than not it is a < sign that is the problem. I have found occasions when enclosing the formula in code tags does not solve the problem but placing a space after the < sign has always worked for me. So if it happens just edit your post and add a space to your formula like this.

=(AND(E59="",D59< TODAY()))

BTW, the outside parentheses are not required in that formula.

 

[SydneyGeek]

If you don't want the spaces, and the parser keeps grabbing your greater than and less than signs, you could use the HTML character symbols instead.
WITHOUT the spaces they are:
Less than -- &lt ;
Greater than -- &gt ;

The semi colon is part of the symbol.

Denis