You can create a form with only 1 record on it and have the escalation
fire against that form.
i.e. Create a form "ArchiveEscalationControl"
Put a Date Only field on it "ArchiveDate"
Create an Escalation "Do Work" that runs against
ArchiveEscalationControl
Escalation does a Set fields to add 1 to ArchiveDate
Escalation could then do a Run-Process action
Application-Query-Delete-Entry "Form to Clean Up" ( 'Date
Modified' <= "$ArchiveDate$" )
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Wednesday, October 29, 2008 12:46 PM
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"
