I try to have the following formula:
The problem is that Monarch doesn't accept this.
Error message: Operand types
I like to have only the date of B if the value of A is <0. How can it work ?
Make your calculated field a Character field, and give it this formula:
[font="courier"]If(A<0,Dtoc(B),"")[/font][/quote]That should do it for you.
thank you it works !!
Retrieving data ...