Last 12 months

NotSQL · May 17, 2006

Im looking to retrieve data for the last 12 months.

Can anyone help with the syntax?

Crowley16 · May 17, 2006

Lol, so you want someone to read your mind as well as answer your question?

--------------------
Procrastinate Now!

NotSQL · May 17, 2006

Yeah, sytanx for the last 12 months a bit like this:

dateadd(mm, datediff(mm, 0, getdate())-12, 0)

LOL!!!

TJRTech · May 17, 2006

I think you are on the right track.

Assuming you have a table, and it has a date/time column, than something like this should work:

Code:

SELECT *
FROM <table>
WHERE <date_column> >= dateadd(mm, -12, GetDate())