You are trying to add an integer to a Timestamp. Rather than do that split the process, create a display only integer field (IntegerField) and perform the following.
Set Fields IntegerField = $TIMESTAMP$ Set Fields IntegerField = IntegerField + (60*60*24*$NumberOfDays$) Set Fields RequiredResolutionField = IntegerField You can do this all in the same Filter. If you ae using ITSM you may find a suitable DisplayOnly integer field you can use is already created. Matt > But I am > Required Resolution Date (date/time field) to > $TIMESTAMP$+(60*60*24*$NumberOfDays$) > > Required Resolution Date is on the current form, but $NumberOfDays$ is > from the selected form; it is an integer field on the form I'm searching. > > Anne Ramey > Remedy System Administrator > State of North Carolina > Office of Information Technology Services (ITS) > Service Delivery Division > ITSM & ITAM Services > Office (919) 754-6521 > Home Office (919) 842-5420 > ITS Service Desk : (919) 754-6000 or (800) 722-3946 > anne.ra...@nc.gov<mailto:anne.ra...@its.nc.gov> > http://its.state.nc.us<http://its.state.nc.us/> > > RHCE, ITIL Foundation > > *********************************** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by > an authorized State Official. > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing > Sent: Thursday, June 03, 2010 11:58 PM > To: arslist@ARSLIST.ORG > Subject: Re: Curious filter issue > > ** > Anne, > The reason it's changing back to 'current transaction' is because you > aren't setting a field on your form with a field from the search....it's > an annoying feature, but it's there.... > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne > Sent: Thursday, June 03, 2010 7:24 PM > To: arslist@ARSLIST.ORG > Subject: Re: Curious filter issue > > ** > The filter log is not helpful, it just shows the field being set to the > current time stamp (because the value isn't being pulled from the form > it's supposed to be because the filter is incorrectly changing to "current > transaction" from the correct selection criteria). I didn't grab the SQL > log, I'll have to do that and see what it says. > > Anne Ramey > *********************************** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by > an authorized State Official. > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza > Sent: Thursday, June 03, 2010 5:56 PM > To: arslist@ARSLIST.ORG > Subject: Re: Curious filter issue > > ** > Depending on what you have used to set that field, take an active link or > a filter or escalation log and see what happens when that piece of > workflow fires... > > An SQL log might be useful too.. > > Joe > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne > Sent: Thursday, June 03, 2010 5:49 PM > To: arslist@ARSLIST.ORG > Subject: Re: Curious filter issue > ** > I checked, it's Date/Time > > Anne Ramey > *********************************** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by > an authorized State Official. > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza > Sent: Thursday, June 03, 2010 4:36 PM > To: arslist@ARSLIST.ORG > Subject: Re: Curious filter issue > > ** > Anne, > > Make sure that the field you have created is not a Date Only field but a > Date and Time field.. If its a Date Only field then your calculation > should be $DATE$*$NumberOfDays$. > > The Date Only field type uses $DATE$ and is different from the Date and > Time field type which uses $TIMESTAMP$ for setting values to it.. > > Cheers > > Joe > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne > Sent: Thursday, June 03, 2010 3:49 PM > To: arslist@ARSLIST.ORG > Subject: Curious filter issue > ** > I have a set fields action that just doesn't like what I'm setting the > field to. I'm trying to set a date field using math; I'm trying to set > Required Resolution Date (date/time field) to > $TIMESTAMP$+(60*60*24*$NumberOfDays$) > on some custom forms and it just doesn't work. If I set it with another > date/time field, it works, but if I try and calculate time using > timestamp, it doesn't. According to abydos, if I put in the calucation, > the other part of the action changes from selecting from my form to > "current transaction"--but this is not reflected on the screen when > looking at the filter in administrator. I came up with a work around, but > I wonder if this is expected behavior, if I'm doing something wrong, or if > I found a weird bug. Has anyone else seen this type of thing before? > > ARS 7.1 > ITSM 7.0.3 > CMDB 2.1 p4 > > Anne Ramey > *********************************** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by > an authorized State Official. > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
