Hello Listers,
I'm trying to learn how to delete records that are past and the End Date
is more than 6 months prior to todays date. I built the escalation and
when I run it nothing happens. Can someone point in the right
directions with the Run Process syntax.
I'm using SQL 2008 and Windows 2008. ITSM is 7.5
The form I'm deleting from is: AP:Alternate
Run IF Qualification is: 'Status' = "Past" (also tried without
setting a Run If Qualification)
Run Process is: Application-Query-Delete-Entry "AP:Alternate"
('Status' = "Past") and ($End Date$ < ($TIMESTAMP$ - (86400 * 180)))
I have also tried: Application-Query-Delete-Entry "AP:Alternate"
('Status' = "Past") and ($End Date$ < ($DATE$ - (86400 * 180)))
Thanks in advance for your time,
Larry B
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
