I need to set work shifts with time conditions based on the created in the incident. For example if an incident was created between 8am to 4pm, I want the 1st shift field on the incident table that I created, to be marked true.
1st shift: 8am-4pm
2nd shift: 4pm-12am
3rd shift: 12am-8am
How can I set these shift values in the incident table with a business rule? If there is a better way to set them without a business rule or a different kind of script, please let me know.
