SQL Syntax to show last 90 days subscribers added....Is this correct way??

Database
Enthusiast

SQL Syntax to show last 90 days subscribers added....Is this correct way??

Select EmailAddress, CreatedDate

From _ListSubscribers

Where ListID = 10630 AND CreatedDate > (Select DATEADD (day,-90,getdate()))

Tags (3)
1 REPLY
Senior Apprentice

Re: SQL Syntax to show last 90 days subscribers added....Is this correct way??

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