Hi, this conditional is acting 'illogically'.
EmploymentEnd date is null for a field I am monitoring for test purposes. This would deny the AND condtion & return false, hence, the entire conditional would return false as it needs both conditions to be true. Right?
Yet the color still turns white (255,255,255)
How can this be if the EmploymentEndDate is null?
Interestingly, the color doesn't turn white for resources that do have a date!!
The logic below dictates that EmplymentEndDate MUST NOT be NULL for the conditional to return true. i.e. White
Also, currently, there are no StartDates that are greater than EmplymentStartDate. Not that this should matter as the consition is settled on the right side of the AND.
What is going on??
Thanks very much for any ideas on this. Here is the code:
if (
({ResourceUsageReportHeader.StartDate1} > {Resource.EmploymentEndDate})
and
(Not Isnull({Resource.EmploymentEndDate}) )
)
then
color(255,255,255)
IP Logged
