Skip to content

Instantly share code, notes, and snippets.

@wvpv

wvpv/sfmc-sql-last-day-of-the-month.sql

Created July 31, 2017 00:03
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save wvpv/80094de7f59fb7cd6d8ebe307ead06aa to your computer and use it in GitHub Desktop.
Save wvpv/80094de7f59fb7cd6d8ebe307ead06aa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sfmc-sql-last-day-of-the-month.sql
select
createdDate
from [dataExtension]
where
dateadd(dd,datediff(dd,0,createdDate), 0) =
dateadd(d, -1, dateadd(m,datediff(m,0,dateadd(dd,datediff(dd,0,getDate()), 0))+1,0))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment