This is what I have but keeps getting error, I have this report I need to generate by Urgency, group and the age of the incident by open date
this is what I have
Open Date & Time],
[_SMDBA_.Incident_Age = datediff] (d, [Open Date & Time], getdate())-----ERROR is at this line
where [Open Date & Time] > '2007-1-1' and [Close Date & Time]= NULL
and [Group Name] = 'NOC'
group by [Group Name] , [Urgency ID],[_SMDBA_.Incident_Age]
Can anyone hep Thanks