Hi,

Is this a bug, or am I missing something?

This works:
case
when p.year = 2200 then p.year
else p.year
end

This gives error: Datatypes are not comparable in expression CASE

case
when p.year = 2200 then p.EndDate
else p.EndDate
end

All I did is change the field from an integer, to a timestamp.

Firebird 2.5
ODS 11.2

Thanks
Maya


[Non-text portions of this message have been removed]