Archives of the TeradataForum

Message Posted: Sun, 16 Mar 2003 @ 21:07:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Try

case when orgnl_srv_dt < date '1960-01-01' then interval '0' month
else ((month_end - orgnl_srv_dt) month(4))
end

I have to leave now, so this will be my last message...

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>