You cannot make NULL values and dates cannot be an empty string.
The answer depends on what you are really trying to do. If this is simply to decide if you want to display the {cpmain.dispdate} field then you can use conditional suppression of that field rather than trying to alter it.
If so:
right click on the {cpmain.dispdate} field
select format field
click on the COmmon Tab
Click on the X-2 (formula) next to the Suppress
enter you formula
{@ Status} = "Active"
Save and close it
However, I am guessing you are trying to do something else here and I am only seeing a small part. If that is the case, what is the whole process?
Edited by DBlank - 03 Nov 2009 at 9:35am
IP Logged
It was that simple and I could never figure it out!!!!!
