Hi, I have got a table where the month and year are separated into two different columns. Example:

Month Year ID
3 2005 123
2 2005 123
1 2005 123
12 2004 123
11 2004 123
10 2004 123
9 2004 123
8 2004 123
7 2004 123
6 2004 123
5 2004 123
4 2004 123
.
.
.
and so on...

I am passing in the last entry for month and year (3, 2005) in my WHERE clause and I want to retrieve all the entries within the past year.. (so returns the 12 records above from 4/2004 to 3/2005).

How can I do this? Note that the fields in that table are not of DATE type.

Thanks!

If you are passing in the month and year of the last row that you want, and you want it and all preceeding rows, you need to use logic like:If you meant something different, can you explain whatever I'm missing?

-PatP

Thanks for your reply.

The problem is I don't want all the preceding data. I just want 12 months before the date that I specify.

So in the case where you had "year < 2005", then that would pick up all my old records, whereas I only want the records from April 2004 to May 2005.

Ah-ha! That makes the request a lot clearer. Now I'd suggest:This should get the range that you want.

-PatP