I'm trying to write a monthly availability report that covers the past 12 months worth of data. Right now, I have this to select the months. It's not a big deal to go in each month and update this one statement to include the new month, but is there a way to say I want the past 12 months without specific using specific dates.
WHERE
( DateTime BETWEEN '6/1/2007' AND '5/31/2008' )
Any help would be greatly appreciated.