Here’s the syntax you’ll use to return data that is greater than or equal to current month:

WHERE CreatedDate >= DATEADD(MONTH, DATEDIFF(MONTH, '20000101', CURRENT_TIMESTAMP),'20000101') 

Here’s how to get only last month's data:

WHERE DATEPART(m, CreatedDate) = DATEPART(m, DATEADD(m, -1, getdate()))
AND DATEPART(yyyy, CreatedDate) = DATEPART(yyyy, DATEADD(m, -1, getdate()))
 

If you have questions, feel free to chat in on the site and we'll be happy to help.

Did this answer your question?