Is the diary required on each modification of the record? If so then you can just do a check against the Modified Date field. If it is not required then adding a new datestamp on when the diary changes would probably be the best way to go Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF AFRL/SNOD Sent: Monday, January 29, 2007 10:59 AM To: [email protected] Subject: Escalation question Importance: High ** 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"
