Shows a list of all assets entered since a specific purchase date. Change the purchase date below for specific results.
select A.ASSET_CODE as [Barcode],
A.DESCRIPTION as [Asset Description],
A.modelNumber as [Asset Model #],
A.PurDate as [Purchase Date],
A.PRODUCT_COde as [Product Code],
I.descriptionV6 as [Product Description]
from tblasset01 A
Left Outer Join tblinvmas I on I.product_code = A.PRODUCT_COde
where A.purdate >= '2016-04-01'