UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Sla Calculation Using Ms Access Query, Office 2010    
 
   
vajeeth
post Jun 20 2019, 10:48 AM
Post#1



Posts: 51
Joined: 29-July 16
From: Chennai, India


Hi Experts,

Good day,

Need your help to calculate SLA in MS Access Query.

Working Hrs starts: 06:00:00
Working Hrs end: 23:00:00


SLA has to be adjusted based on Importance of the job.

For High Importance: 17 Hrs SLA
For Medium Importance: 34 Hrs SLA
For Low Importance: 51 Hrs SLA

Saturday and Sunday not applicable(Working days are Monday to Friday). For now I am maintaining it in excel. But i need to calculate it in Access query.

I need your help in 2 things.

1. Scenario

Task Received: 20-06-2019 21:00:00

The SLA end date/time has to be automatically calculated based on Importance as mentioned above.

Result: I need to find out how many hrs left for me to complete this task from current date/time.

2. Scenario

Task Received: 20-06-2019 21:00:00

If the Task is completed less than or more than SLA hrs.

Result:I need to find out whether it is "Out of SLA" or "Within SLA" using task completed date/time.

Thanks in advance.
This post has been edited by vajeeth: Jun 20 2019, 10:54 AM
Go to the top of the page
 

Posts in this topic
- vajeeth   Sla Calculation Using Ms Access Query   Jun 20 2019, 10:48 AM
- - ADezii   I am not exactly sure if I understand the nature o...   Jun 20 2019, 01:57 PM
- - WildBird   Have you considered public holidays in your scenar...   Jun 20 2019, 05:27 PM
- - ADezii   @WildBird: What exactly is a SLA?   Jun 20 2019, 05:44 PM
|- - WildBird   SLA = Service Level Agreement Last place I worked,...   Jun 20 2019, 07:11 PM
|- - ADezii   Thanks for the thorough explanation. In this conte...   Jun 21 2019, 05:39 AM
|- - vajeeth   Hi ADezii, Yes, it works perfectly. Thanks for yo...   Jun 23 2019, 07:59 PM
|- - vajeeth   Hi ADezii, I just came to find one issue. The ta...   Jun 23 2019, 10:32 PM
|- - WildBird   I dont have any code with me, I left it at my old ...   Jun 24 2019, 12:04 AM
|- - ADezii   QUOTE I just came to find one issue. The task was ...   Jun 24 2019, 11:36 AM
|- - vajeeth   Hi ADezii, Task can be received at any time even ...   Jun 24 2019, 11:31 PM
|- - Minty   Like Wildbird I have programmed SLA achievement / ...   Jun 25 2019, 05:40 AM
|- - ADezii   I have made a couple of Revisions to the Code, ess...   Jun 25 2019, 07:13 AM
|- - vajeeth   Thanks ADezii, You are awesome. I have work around...   Jun 25 2019, 08:15 PM
|- - WildBird   I would write a number of test cases and expected ...   Jun 25 2019, 11:07 PM
|- - WildBird   By test table, have TaskReceivedTime, Importance, ...   Jun 25 2019, 11:18 PM
|- - ADezii   @WildBird: First and foremost, thank you for your...   Jun 26 2019, 08:21 AM
|- - ADezii   @vajeeth: I took mostly all of the suggestions men...   Jun 26 2019, 10:47 AM
|- - vajeeth   Hi ADezii, Yes, I will check on the code and reve...   Jun 27 2019, 04:28 AM
|- - vajeeth   Hi ADezii, Now we get 1 Mins less SLA End time if...   Jun 27 2019, 08:41 PM
|- - ADezii   The Code and Logic was never designed to work with...   Jun 28 2019, 08:52 AM
|- - vajeeth   Hi Adezii, Good day!!! I think I hav...   Jul 1 2019, 11:21 PM
|- - ADezii   QUOTE > If mail is received on 7/5/2019 05:20:3...   Jul 2 2019, 07:01 AM
|- - ADezii   I adjusted the Code in the fRoundSeconds() Functio...   Jul 2 2019, 08:46 AM
|- - vajeeth   Hi ADezii, You are amazing and thank you so much...   Jul 3 2019, 03:08 AM
|- - ADezii   Much of the credit belongs to WildBird who picked ...   Jul 3 2019, 07:07 AM
- - vajeeth   Hi WildBird, Yes, but i thought we cant make that...   Jun 23 2019, 08:01 PM
- - WildBird   Queries are quicker, but code can be easier to doc...   Jun 23 2019, 08:46 PM
- - vajeeth   Hi WildBird, Yes I can understand that. Holidays ...   Jun 23 2019, 10:25 PM



Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 09:47 PM