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 🙂