Hi,
Going via an integer-field might work better, even though the example you
gave looks ok.
Action 1:
Set-Fields:
tmpInt = $TIMESTAMP$ + ($Escalate Minutes$ * 60)
Action 2:
Set-Fields:
Escalate Date = $tmpInt$
Make sure that it really a Date/Time-field and not a Date-field...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> I have been dealing with a major frustration that I am hoping someone can
> clear up for me. Our organization has recently moved from ARS 6.3/ITSM
> 5.6 to ARS 7.5/ITSM 7.6. I am working on recreating some of our old
> custom workflow, and I am finding that I can no longer do calculations on
> a Date/Time field. The same functionality that worked in the previous
> version returns the error "Data types are not appropriate for relational
> operation." in the new version. I am trying to do a Set Field action that
> sets the value of the field 'Escalate Date' to $TIMESTAMP$ + ($Escalate
> Minutes$ * 60). This same workflow works in ARS. 6.3. I have noticed
> this many times throughout our upgrade process, and figured it was time to
> ask the experts. Any ideas on this would be great. I have a feeling it
> is something easy that I am just overlooking.
>
> ARS - 7.5
> ITSM - 7.6
> Windows 2008
> SQL 2005
>
> Thanks,
>
> Shane Buchholz
> Systems Analyst II - Remedy
> Information Services Operations
> Samaritan Health Services
>
> ________________________________
> Confidentiality Notice: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
