Archives of the TeradataForum

Message Posted: Wed, 31 Dec 2003 @ 17:02:35 GMT

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

Nope, it is working as designed. Add_Months does exactly that deals only with the month. If your date is 2003-11-30 and you subtract one from 11 you get 10. It doesn't actually figure out what the days are, just subtracts the appropriate number or adds the appropriate number to the month.

Bill Grenwelge
Data Warehouse
Union Planters Bank

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