Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2002 @ 21:15:33 GMT

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

Hi,here is a sample SQL where I specify a date, it's 3 days after todays date.

select count(distinct(ban))
from vslc007_billing_account
where sys_creation_date <= '20020126'

What can be done to make that date automated in respect to everytime it's ran it's always going to be 3 days after the current day? I don't want to hand change it and 36 others every 2 weeks.

Thanks, Jay

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