I need a report for warranty start date (accurate purchase date) but it in more usable format
I found this report which is how I want it to look.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,tblAssets.AssetID,tblAssetCustom.PurchaseDate As [Purchase Date],Year(tblAssetCustom.PurchaseDate) As [Purchase Year],Year(tblAssetCustom.Pur...