Not sure which versions of SQL Server this works in (but it works in 2005).

declare @dt_date datetime;

declare @dt_date_prev datetime;

set @dt_date = convert(datetime,'2009-09-01');

set @dt_date_prev = @dt_date-1;