Hmm ignore that, I re-read your thread and it would appear that what you are saying is that $NumberOfDays$ does not have a value?
Is that correct? > 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"
