Relative Duration

Dipali Pawar2
Tera Contributor

Hello, I am working on Record producer and I have to create SLA for that, In the SLA condition the SLA duration should be Four working days prior to value date specified by requestor in form(value date is the field in the record Producer).

Lets say if we select value  date as 31st July in the form then SLA should start on 27th July. 

Please provide solution it's quite urgent 

1 ACCEPTED SOLUTION

dmathur09
Kilo Sage
Kilo Sage

Hi Dipali,

You would need to create one more field say xyz which would be populated based on the value date. So if the user selects 31st July on value date, the xyz field would be populated with 27th July. Once that is done, in the SLA part you can use set start to field as the xyz fieldfind_real_file.png You can make the xyz field hidden, so that users are unable to see that field.

Let me know in case you have any further queries

If you think my response is helpful for you? If yes, mark it as correct answer and close the loop so that it would help future readers as well.

Regards,
Deepankar Mathur

View solution in original post

7 REPLIES 7

dmathur09
Kilo Sage
Kilo Sage

Hi Dipali,

You would need to create one more field say xyz which would be populated based on the value date. So if the user selects 31st July on value date, the xyz field would be populated with 27th July. Once that is done, in the SLA part you can use set start to field as the xyz fieldfind_real_file.png You can make the xyz field hidden, so that users are unable to see that field.

Let me know in case you have any further queries

If you think my response is helpful for you? If yes, mark it as correct answer and close the loop so that it would help future readers as well.

Regards,
Deepankar Mathur

Thanks for the reply , I have created a field like u said but I can not see that field in set start to field  dropdown menu.

Hi Dipali,

You would need to create a new field on the incident table. I did it in my PDI, created a new field on incident table called "value date" field and I am able to select it in the SLA

find_real_file.png

Let me know in case you have any further queries

If you think my response is helpful for you? If yes, mark it as correct answer and close the loop so that it would help future readers as well.

Regards,
Deepankar Mathur