If you need to reference the start or the end of the month in SQL Server it can be a bit tricky. Here is how to do it:

Start of Month: DATEDIFF(MONTH, '20000101', CURRENT_TIMESTAMP),'20000101') 

End of Month:
DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,CURRENT_TIMESTAMP)+1,0))
 

If you have any questions please email support@grow.com or chat in on the site.

Did this answer your question?