Business Objects sql for previous month
Posted on 2011-10-07
I need assistance modifying the following SQL so it pulls the incidents that were created in the previous month.
( SCN.INCIDENT.ASSIGNMENT_GROUP IN ( 'Purchasing', 'Accounting','Engineering','Fleet' )
SCN.INCIDENT.STATUS IN ( 'Pending Vendor','Open','Pending Other','Completed','Pending Customer','Work In Progress','Accepted','Waiting for Part','Referred','Part on Order','Pending Change' )