Looks like it worked thanks for all your help!!!!

Declare @Date char(8), @CurrentMonth int, @LengthFutureMonth int, @FutureMonth char(2), @Year char(4), @FinalDate1 char(8), @FinalDate2 char(8)

Set @Date = (select dateidentifier from tbldonoterase)

Set @Year = Left(@Date, 4)

Set @CurrentMonth = right(Left(@Date,6), 2)

Set...

Declare @rundate char(8)

set @rundate = (select dateidentifier from dbo.tbldonoterase)

This is the date from the previous day inwhich we run reports. I'm using this as the way to get the month...