Hello everyone,
So, I have two text boxes with a Data Type of Date/Time. I also have a check box with a Data Type of Yes/No.
Here is a Gyazo link (picture) as it would not allow me to upload a .png snapshot using Snipping Tool.
https://gyazo.com/233b4e8e91e217baf40177814d4ad407 (don't worry, the link is perfectly safe.)
What I would love, would be for the SLA date be 20 working days (Mon-Fri) after whatever the Date Received is and IF the Fast Track is YES then for the SLA date to be 10 working days from whenever the Date Received is. Let me break it down visually to explain it better.
EXAMPLE SCENARIO
Now imagine a user entered the following data...
Date Received: 02/01/2017 (Monday 2nd January 2017) (so the SLA date would be 20 working days from the 2nd which would be 06/02/2017)
Fast Track: No
SLA Date: 06/02/2017 (Monday 6th February 2017)
Let's say the Fast Track was Yes
Date Received: 02/01/2017 (Monday 2nd January 2017)
Fast Track: Yes
SLA Date: 16/02/2017 (Monday 16th January 2017)
I have no idea how to do this as I'm a beginner with Access. How would we be able to tell access to ignore Saturday's and Sunday's? And for it to be as accurate as possible, I would also need for access to ignore the holiday dates, for example Christmas, national holidays, etc... these dates could not be included. I hope this makes sense, please don't hesitate to ask me to break it down further.
Thanks for any help in advanced! It's greatly appreciated.
-Enigma