So you are suggesting handling it in the Stored proc...
Here is my current procedure:
declare @currentdate datetime
set @currentdate = getdate()
SELECT dbo.CreateReportString('NBUR1200-1', A.NBUCMPNY, A.NBUDEPT) as Co_Dept,
dateadd(d, -1, convert(datetime, cast(month(@currentdate) as varchar(2)) +...