Remedy Newby here - 

I have an escalation that I want to fire for all records with a status
of 'Working' and that have not had a diary entry posted in the last 36
hours.  I want to set the status to Assigned. 

How can I compare the most recent diary entry for a ticket's work log
field to the current system date/time?  

---
Michael Cupp, Jr., Contractor, RCF
Oracle Database Administrator
AFRL EBS Helpdesk Team Lead
AFRL/SNOD Enterprise Operations Center
Wright-Patterson AFB, Ohio
DSN 785-3827


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Reply via email to