are you asking for t-sql or ssrs expression?
t-sql expression will be like
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE())-1,0) AS StartofprevMonth,
DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)-1 AS EndOfPrevMonth
ssrs you will do like
=DateAdd(DateInterval.Month,DateDiff(DateInterval.Month, #1/1/1900#, Now())-1,#1/1/1900#)
=DateAdd(DateInterval.Day,-1,DateAdd(DateInterval.Month,DateDiff(DateInterval.Month, #1/1/1900#, Now()),#1/1/1900#))
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Grabbing data for last month
Posted - 08/14/2012 : 13:03:33
