Displaying a value in a blank field 1

[gscheepers]

Hi everyone,

I'm having problems with the following formula:

If date({EMPLOYEEJOB.End}) > {?End Date} or isnull({EMPLOYEEJOB.End})
then {?End Date} else
date({EMPLOYEEJOB.End});

I'm trying to display the {?End Date} if {EMPLOYEEJOB.End} > {?End Date} or if there's no value in the {EMPLOYEEJOB.End} field. When I use the formula above, it does not display the {?End Date} value where there's no value, but keeps it blank in stead.

Your help would be appreciated!

Many thanks, Gerhard Scheepers

"Great souls have wills; feeble ones only wishes..."

 

[synapsevampire]

Perhaps the field is never null, try:

If isnull({EMPLOYEEJOB.End})
or
date({EMPLOYEEJOB.End}) > {?End Date}
or
date({EMPLOYEEJOB.End}) < date(1920,1,1) then
// this last being a sanity check against the date
{?End Date}
else
date({EMPLOYEEJOB.End})

I've read that Crystal sometimes ignores the isnull() test if it isn't first in the set of tests, so I changed the order.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[gscheepers]

Thanks! That worked great!
Gerhard Scheepers

&quot;Great souls have wills; feeble ones only wishes...&quot;