I am trying to establish a filter to pull requests made exactly 90 days ago and I am having trouble getting anything to work. The system dates available don't get me close. I know there is probably something simple to put into the compare value field that will enter a date. Any idea?

I am in the query portion of Event Manager and I am using dbo.Absences.syscreated field. I am wanting todays date - 90 days

Thanks,

Manville

on the SQL portion of the query builder check the box to manually modify the query and use a condition comparing syscreated to (getdate()-90) fro example:

select * from absences where syscreated <= (getdate()-90)

I must be doing something wrong.....

SELECT DISTINCT dbo.Absences.HID AS "HID", dbo.RequestTasks.Created AS "Created", dbo.Absences.ProjectNumber AS "ProjectNumber", dbo.Absences.syscreated AS "syscreated", dbo.cicmpy.cmp_wwn AS "cmp_wwn" FROM ((dbo.Absences LEFT OUTER JOIN dbo.cicmpy ON dbo.Absences.CustomerID = dbo.cicmpy.cmp_wwn) LEFT OUTER JOIN dbo.RequestTasks ON dbo.Absences.ID = dbo.RequestTasks.RequestID) WHERE dbo.Absences.Type = 88 AND select * from absences where syscreated <= (getdate()-90)

I get an invalid syntax near select

You've got two SELECT statements together there. Try this;

PERFECT!!!!

Thank you, It worked.