Archives of the TeradataForum

Message Posted: Thu, 31 Jul 2003 @ 09:27:14 GMT

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

Sorry , I deleted the original posting so not sure if I am answering the exact question you asked .... but would something like this work

(extract(year from ship_to_date+2)*100+((extract (day from ship_to_date+2)-1)/7)+1) >200302

Howard

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