Forum Discussion
MichaelQuist
8 years agoQrew Trainee
I wrote my own formulas to do this.. and they seem to be accurate the way I did this. The formula may be written in a Novice manner so I apologize, I'm not a QuickBase expert so if this can be re-written to be better please by all means do so.
I'm only posting this so that others can use it if they find it useful.
First: I created a field in my table called [SLA Start Date] This date is what will be used to base the SLA Hours off of. I use this first formula to populate the SLA Start Date field. It basically checks the business hours (SLA Hours) for each day and set's it to the right date/time accordingly.
Example: SLA Hours is 9:00am to 8:00pm.. a call created at 8:00am will show the SLA Start as 9:00am the same day it's created.. a call created at 8:30pm will show the SLA Start as 9:00am the next valid SLA day.
I'm only posting this so that others can use it if they find it useful.
First: I created a field in my table called [SLA Start Date] This date is what will be used to base the SLA Hours off of. I use this first formula to populate the SLA Start Date field. It basically checks the business hours (SLA Hours) for each day and set's it to the right date/time accordingly.
Example: SLA Hours is 9:00am to 8:00pm.. a call created at 8:00am will show the SLA Start as 9:00am the same day it's created.. a call created at 8:30pm will show the SLA Start as 9:00am the next valid SLA day.