Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
select
emailAddress
from [dataExtension]
where createdDate < convert(date, getDate())
and createdDate >= convert(date, getDate()-30)
@web20opensource

This comment has been minimized.

Copy link

@web20opensource 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

@wvpv

This comment has been minimized.

Copy link
Owner Author

@wvpv wvpv commented May 4, 2020

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

@web20opensource

This comment has been minimized.

Copy link

@web20opensource 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