SQL Query: Prior Month Date 1

[mrpauly]

Hi,

I need help creating a query that pulls all records from the prior month date.

For example, if the report is ran today (Jan 4th) I want all records for December.

Thanks,
Paul

 

[maswien]

something like:

select * from myTable
where datediff(mm, date_column, getdate()) = 1