Service Desk Practitioners Forum
cancel

Help creating rule

SOLVED
Go to solution
Highlighted
Jan Gunnar Helg
Honored Contributor.

Help creating rule

I am trying to create a rule in our change form.

Using following fields:
Actual finish (date/time field)
Post Implementation Period (number field)
Post Implementation Period Finished (date/time field)

Once the status is set to "Release to production finished" I want the "Post Implementation Period Finished" field set to the sum of "Actual Finish" + "Post Implementation Period".

The Post Implementation Period field is manually populated with X days.

Can this be done? and if so how?
5 REPLIES
Vasily Kamenev
Acclaimed Contributor.
Solution

Re: Help creating rule

HI
SD can't summary to datetime fileds, so you need use external calculator - create one script, on any languages, then use sd_event to post result to SD.

Vasily
George M. Meneg
Acclaimed Contributor.

Re: Help creating rule

That's not entirely correct. Doing some dirty little tricks you can add a custom duration to a date field. However SP19 or later is required. Have a look at http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1029966
menes fhtagn
Jan Gunnar Helg
Honored Contributor.

Re: Help creating rule

George, I read your other post on this. I do not see how I can use your approach for my issue? Could you explain?
Jan Gunnar Helg
Honored Contributor.

Re: Help creating rule

George,

I read your other post, but I do not see how I can use your method for my issue. Could you perhaps explain it to me?
George M. Meneg
Acclaimed Contributor.

Re: Help creating rule

Hello,

You want to add duration to a date but ovsd doesn't let you. So the trick is to convert date to a double number, add to that number the duration (duration is also a double) and convert the result to date!
menes fhtagn