Hi

[Code = "sql"]

DECLARE @dayofmonth int

DECLARE @dateprmonth datetime

/* stores one day before day of the month */

SET @dayofmonth = datepart( dd,dateadd (mm,-1 ,getdate()) ) -1

/* stores the previous month date from current date*/

SET @dateprmonth = dateadd(m,-1,getdate())

SELECT dateAdd(dd,0,DateDiff(dd,0,@dateprmonth-@dayofmonth)) AS [FIRST_DATE_OF_PREVIOUS_MONTH],

dateAdd(dd,0,DateDiff(dd,0,dateAdd(MM,1,(@dateprmonth-@dayofmonth )))) -1 AS [LAST_DATE_OF_PREVIOUS_MONTH]

[/Code]

above script to get first and last day of the previous month, if you run your script for between those two dates and set up a report to report run on 2nd of every month.

done and dusted 🙂