5 Replies Latest reply on Jun 4, 2008 2:38 PM by sgreath

    Little help w/ SQL Query please

    sgreath

      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.