SQL Query for Last Month Data | The ASP.NET Forums
To get the date for last month, try: SELECT DATEADD(MM, -1, GETDATE()) GETDATE() will return the current date and time. DATEADD(...) will take 1 month off from the current date and time. To get last month data, do: SELECT * FROM yourTable WHERE sales ......