26 Jun 2012
DATEADD doesn't exists in Teradata SQL, depending on some settings it might work in SQL Assistant using an ODBC connection.
But it's much easier in TD SQL:
CreatedDate > current_date - 90
Dieter
You must sign in to leave a comment.
Select EmailAddress, CreatedDate
From _ListSubscribers
Where ListID = 10630 AND CreatedDate > (Select DATEADD (day,-90,getdate()))