Is it safe to say this in the view:

select *

from accounts

where accountopendate <= dateadd(month, -12, getdate())

Will this give me everything from the last 12 months?

I looked at this and said I hope that I explained this right. If I have a field called 'accountopendate' and I want to pull everything from the last 12...

I'm a newbie (as if you couldn't tell) any web based or anything I can get a crash course...lol...

Regards

Joe

(A Wanna be developer overnight...lol)

No it's not my homework, just knew I could do it, but I had a brain cramp. Not much different than what I thought, looks like ya really got to...