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

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

Last active May 4, 2020 01:54

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/web20opensource/142220f5f2f922402247aa67bf7414aa.js"></script>
Save web20opensource/142220f5f2f922402247aa67bf7414aa 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()-30)

Author

web20opensource commented May 4, 2020 •

edited

seems the comparison operators were inverted. I have updated them to shown as is expected to be.
And if the time frame is up to today, there's no really needed to include a time frame limit up, correct?

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