The code in my previous post will also strip off the time 😉

The other question is why use more variables and code than needed?

DECLARE @d SMALLDATETIME

SELECT DATEADD(mm, DATEDIFF(mm, 0, ISNULL(@d, GETDATE())), 0)

SELECT DATEADD(d, -1, DATEADD(mm, 1 + DATEDIFF(mm, 0, ISNULL(@d, GETDATE())),...

Thanks for the reply. No, this is not a named instance. I'm just trying to remotely connect to SSAS on another server. I guess that is just...