SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query
This blog shows how to do an decrease a date value to 4 months in the output using SQL Query
Example:
SELECT DATEADD(mm, -4, '8/1/2011')
The expected result would be 2011-04-01 00:00:00.000