wvpv/sfmc-sql-created-in-the-last-thirty-days.sql

Last active May 4, 2020 16:19

Star 0 You must be signed in to star a gist
Fork 2 You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wvpv/73b2ba7bb5edf02169b2b7a3688bd0bd.js"></script>
Save wvpv/73b2ba7bb5edf02169b2b7a3688bd0bd to your computer and use it in GitHub Desktop.

Download ZIP

Raw

sfmc-sql-created-in-the-last-thirty-days.sql

	select
	emailAddress
	from [dataExtension]
	where createdDate < convert(date, getDate())
	and createdDate >= convert(date, getDate()-30)

web20opensource commented May 4, 2020

Adam, can you please review this cloned gist?
Seems the comparison operators were inverted. I have updated them to shown as is expected to be.

I caught this reading your blog

Author

wvpv commented May 4, 2020

Yes, you're correct. Updated. Thanks for letting me know.

web20opensource commented May 4, 2020

No problem. Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment