DECLARE @Today DATETIME
SET @Today = GETDATE()
DECLARE @EndDate DATETIME
DECLARE @StrEndDate VARCHAR(8)
SET @EndDate = DATEADD(day, -1, @Today)
SELECT @EndDate
SET @StrEndDate = replace(str(year(@EndDate), 4), ' ', '0') +
replace(str(month(@EndDate),2), ' ', '0') +
replace(str(day(@EndDate),2), ' ', '0')
SELECT @StrEndDate
