In this situation you would need the escalation to modify EVERY record, and have a series of filters fire on modify that performed the remove on only those records that matched
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, October 29, 2008 11:46 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a qualification doesn't work Mark, I'm having the same problems with Date fields for some time now (these are Date only fields, not Date/Time fields). I think it DOES have something to do with the quotation marks. When I do this: 'mydate' < "6/21/2008" it works, But when I do: 'mydate' < ($DATE$ - (((60 * 60) * 24) * 120)) It doesn't work. I've tried 'mydate' < ("$DATE$" - (((60 * 60) * 24) * 120)) as well. I've tried 'mydate' < ($TIMESTAMP$ - (((60 * 60) * 24) * 120)) as well. I like LJ's suggestion, but the question is, where does the ztmp_datefield field go if you are doing a escalation? On every single record? (I would like to delete all records that are more than 120 days old) <note to self: NEVER use date fields. ALWAYS use Date/Time fields and make the display type "Date" if you want a "date" field> If 'mydate' was a date/time field (whether it be displayed as date or date/time) this query would work just fine.... Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Tuesday, October 28, 2008 6:56 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a qualification doesn't work > An easy way to do this is to use the multipliers. You will also need > to use $TIMESTAMP$ > > 'my_date_field' > ($TIMESTAMP$ + (60*60*24*182)) > > $TIMESTAMP$ returns the number of seconds elapsed since midnight > Coordinated Universal Time (UTC) of January 1, 1970. > > Guess what platform Remedy ARS was first built upon? That's right UNIX. > There used to be 3 clients. Anyone know what they were? Note: Remedy > ARS was built before there was a Public Internet. Come to think of it, > there may have been 4 clients at one time, but there may not have been > one for IBM OS/2. > > When you do it this way, you can substitute a $variable or a number > whenever you like. I've tried that too, of course. When your my_date_field is a DATE field the example you're showing will n o t work. At least on my 6.3 patch 024 it just doesn't work. Thanks anyway! Mark ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"