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

Database

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
N/A

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