Calculate sla relative duration based on wm_task location and time zone

msc
Tera Contributor

‎05-25-2025 06:35 AM

Hi All,

I need to help to write script on relative duration based on work order task sla schedule and location timezone.

If task has created before and during hours then next day will be the business elapsed time and if task has created after business hours then we need to add one more extra day for it means +1day

  • Here on work task table we have sla schedule field which refers to the cmn_schedule table and based on login user and task time zone we need to calculate and add days for the breach time on sla 
0 Helpfuls
  • 360 Views
1 REPLY 1

shantanu_patel8
Mega Guru

‎05-25-2025 09:58 PM

Hi @msc ,

 

As far as I know the functionality you are trying to look for is the expected behavior of SLA definition and schedules.

 

Can you please describe the exact issue you are facing with screenshots.

 

Please mark the answer helpful clicking on 👍 and correct if it helps the issue. Happy scripting 🙂

 

-Shantanu

0 Helpfuls