• I'll take a shot in the dark. You're setting the current date to last month. Try setting it to this month.

    DATEADD(mm,0,getdate())