easy question, I have a query and I need to select records only for the past completed months.
so if the report let's say is run today 02/07/2014, I do not want to see records from February, just start date way back in past but end date to last completed month.
CostLine cl LEFT OUTER JOIN
InvoiceCostLine icl ON
cl.ItemNumber = icl.ItemNumber
cl.SalesQuoteNumber = '09320-1'
icl.InvoiceType = 'STANDARD'
DocumentDate << here is the help I need :) >>
Any help would be great.