I would say a simple solution to this would be to add a hidden display only date/time field set to only date (which would always tell you midnight) then display where
$Target Date$ >= $tempdate/time$ and $Target Date$ <= $tempdate/time$ + 86400 Another option would be to take a timestamp and devide it by 86400 into an int field (dropping the fractional answer) then multiply it by 86400 to get today at midnight. Then back to the qualification above. HTH, Brian Goralczyk On Wed, Nov 27, 2013 at 8:26 AM, David Boylan <[email protected]>wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
