I'm creating a new Sys Predefined Query that will appear on the Incident
Console. The spec is that, the powers that be, want to see every incident that
has a Target Date of today, even if it is after the server timestamp.
I've come up with this - ((($\TIMESTAMP$ - '1000005261') >= ((60 * 60) * 1))
OR ('1000005261' = $\NULL$ ) ) AND 'Status' < "Resolved"
'1000005261' being the Target date.
Of course this only shows those of a Target date before the Server timestamp.
Suggestions on how to show those (up to 23 hours) after the DATE default of
12:00 AM?
ARS 8.1
ITSM 8.1
Thanks,
Dave
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
