Hi Guys,

How can I filter the results on my reports to show only 2014 full year or 2015 invoice dates?

Product.ProductDescription, CustomerAccount.Description, SalesInvoice.InvoiceDate, 
                         Company.CompanyName

Thanks,

• Edited by Mo Yusuf 15 hours 3 minutes ago

select * from [YourTableName] Where DatePart(yyyy,Invoicedate) IN(2014,2015)

Hi ,

you can also  filer as below

Where  Year(SalesInvoice.InvoiceDate) in (2014,2015)

Many Thanks

Chandra

---------------------------------------------------------------------------------------------

Please mark the post as Answered If this solves your  query

Where should I apply these filters ? In the report builder or query?