Is it possible to have a condition in Service Level Agreement screen use a date type field, instead of hardcoded date after the comparison

(0) Share

Report

Posted on by Ainsley

Hello,

Im trying to use SLA, and based off some conditions, i.e. work order has been "closed-posted" but within a selected quarter.

I created a calculated field that has today's date, which should be "on or before" the selected "quarter", the issue im having is that im only allowed to pass a date and now field of type "date"

please see screenshot below, is there a workaround? Or I'm missing something?

Thanks for any help!

All responses (5)

Answers (1)

LuHao 40,872 on at

Like (0)

Report

RE: Is it possible to have a condition in Service Level Agreement screen use a date type field, instead of hardcoded date after the comparison

Hi partner,

Has the problem been solved?

Please click Yes under "Did this answer your question?" to close this thread.

Thanks. ;)
Suggested answer

Linn Zaw Win 3,405 on at

Like (1)

Report
RE: Is it possible to have a condition in Service Level Agreement screen use a date type field, instead of hardcoded date after the comparison

As LuHao mentioned, the failure condition can only be the duration based on the "Applicable From" field in SLA.

But if you want to make all the SLA of the records to be expired at the quarter's end date, there is a workaround solution.

Create a new date field in the Work Order

Create a flow to set the custom date field with x days before the current quarter's end date. (e.g. 14 days before the current quarter's end date 30 Jun 2020 would be 16 Jun 2020)

Create the Work Order SLA with "Applicable From" field to the custom date field from step 1.

Set the SLA Item "Failure after" to x days from step 2 (e.g. 14 days)

Then, the SLA for all Work Order records created between 1 Apr 2020 to 30 Jun 2020 will be failed on 30 Jun 2020. You can tweak the flow in step 2 to get the desired outcome.
LuHao 40,872 on at

Like (0)

Report

RE: Is it possible to have a condition in Service Level Agreement screen use a date type field, instead of hardcoded date after the comparison

Hi Ainsley,

Unfortunately, the failure condition can only be a fixed time.
Ainsley 90 on at

Like (0)

Report

RE: Is it possible to have a condition in Service Level Agreement screen use a date type field, instead of hardcoded date after the comparison

Thanks! my only other issue would be the failure condition. Which would have to be dynamic, as it would have to be today's date minus the quarter's end date which equal the remaining validate days to complete the task, is it possible to have dynamic values in the failure condition?
Verified answer

LuHao 40,872 on at

Like (1)

Report

RE: Is it possible to have a condition in Service Level Agreement screen use a date type field, instead of hardcoded date after the comparison

Hi Ainsley,

Unfortunately, it is impossible

But We can fulfill your needs in other ways.

To compare two dates, we can new a calculated field to represent the difference between "quarter" and today's date. Then use this calculated field in the SLA.

First refer to these blogs to know calculated field.

https://www.powerobjects.com/blog/2018/02/12/how-to-calculate-number-of-days-between-two-date-and-time-fields/

New a field, and select Whole Number and Calculated. Edit the calculated logic as follow.

If the value of this calculated field is greater than 0, then the date of "quarter" is greater than today.

So set the SLA item condition to the calculated field is Less Than or Equal To 0.