Report Request - Adding Additional Years

[akira]

Hello,

I am making a report right now and would like to add PC Replacement Date on there. Our replacement cycle is every 5 years, so I was wondering how I could add 5 years to the PC Purchase Date in my report.

Below is the code for my report:

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName As Asset,
  tblAssets.Domain,
  tblAssetCustom.Manufacturer As Make,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.Username,
  tblAssets.Lastseen As [Last Seen],
  tblAssetCustom.PurchaseDate As [PC Purchase Date],
  tblAssetCustom.Warrantydate As [Warranty End Date],
  Max(tblQuickFixEngineering.Lastchanged) As [Last Patch Detected]
From tblAssets
  Inner Join tblQuickFixEngineering On tblAssets.AssetID =
    tblQuickFixEngineering.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
    tblQuickFixEngineering.QFEID
Group By tsysOS.Image,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname,
  tblAssets.Username,
  tblAssets.Lastseen,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate
Order By Asset

Thank you!

[akira]

Thanks!

[RCorbeil]

Refer to the DateAdd() function.

DateAdd(year, 5, tblAssetCustom.PurchaseDate) AS [Replacement Date]