/sfmc-sql-last-day-of-the-month.sql
Created Jul 31, 2017
| 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