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:

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

Did this answer your question?