report option for last seen = this month

[ratiopharm]

Hello
I am looking at reports for PC's that have software updated. some PC's have not connected in a while ( > 60 days) . Is there a way in report builder to make so that the tblcomputters.lastseen value can be configured to equal "september" or whatever month you are in
Thanks in advance

[Hemoco]

You should get this:

[ratiopharm]

hello
We're not understanding each other. I am telling you that no matter what I do the "=" sign is attached to the prefix of this statement

tblComputers.Lastseen < GetDate() - 60

It does not matter where on the screen I edit or what qualifiers I have in the GUI window, see attached file

[Hemoco]

You don't need the grouping in this example.

[ratiopharm]

Thanks but the problem is whenever you make changes in the GUI . the application always add a "=" , see attachment

[Hemoco]

Try:

Select tblComputers.Computername, tblComputers.Username, tblComputers.Lastseen
From tblComputers
where tblComputers.Lastseen < GetDate() - 30

[ratiopharm]

getting error message , see attachment.

Select tblComputers.Computername, tblComputers.Username, tblComputers.Lastseen
From tblComputers
Having tblComputers.Lastseen = tblComputers.Lastseen < GetDate() - 30

[Hemoco]

You can use:

where lastseen < getdate()-60