That time would be hard to capture and use in a qualification in a Escalation so instead why don't you use a Date/Time field specifically for that and have a filter, which when the TR value of the diary is not null, set the Date/Time field.. Run your Escalation against this Date/Time field
Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: "Cupp, Michael E Jr. CTR USAF AFRL/SNOD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, January 29, 2007 11:58:55 AM Subject: Escalation question ** 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 ____________________________________________________________________________________ The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"