Archives of the TeradataForum

Message Posted: Sat, 10 Mar 2012 @ 22:40:29 GMT

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

Just remove the "+ 1", MOD 7 returns a value between 0 and 6, but when you add 1 you get 7 for today :-)

Dieter

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