Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 20:16:01 GMT

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

You could use the ADD_MONTHS function:

     case
        when EXPIRATION_DATE < CURRENT_DATE
             then ADD_MONTHS(EXPIRATION_DATE, 12)
             else EXPIRATION_DATE
        end as NEW_DATE

Wayne Sexton

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