2> 3> select DATEADD(month, -1, '2002-09-30 11:35:00') 4> GO ----------------------- 2002-08-30 11:35:00.000 (1 rows affected)