Date criteria

[kenm]

I'm trying to make a report that only shows older bios's by date.

How do I set the criteria in the report?

Like this?
< 01/01/2013

[kenm]

That worked. Thanks!

[Hemoco · Accepted solution]

Hi,

Use the report down here for the information you're after:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblBIOS.Caption,
tblBIOS.ReleaseDate
From tblAssets
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblBIOS.ReleaseDate < '2013-01-01'

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.