How to get total count of records which are created out of business hours

[srinivas48]

Hi All,

I have a requirement like I need to show number records in report which are raised out of business hours.

In a custom table we have a field called region, We have total 22 regions, after submission each record will attach SLA based on region selection Ex: if the user select ABC as a region and if record got submitted then the SLA will start at particular schedule time. Each region we have different Schedules, in the above ex that ABC region schedule time is 7:20 AM start and it will end at 9:30 PM (Business Hours). So if the record submitted after 9:30 PM (Out of business hours) here I want to fetch total number of records which are created within business hours and out of business hours. 

Any suggestion is very helpful.

Thank you

[Tony Chatfield1]

Hi, I would consider adding a true\false field to your task table using it to track if the task was creating during business hours and calculate this field with a before insert business rule, that way each task will have a created defined indication of when it was created and your reporting is simply a reference to this field.
If you need to report on historical data then you can populate this field new for existing records via a fix script (or background script) run outside of core business hours with minimum impact to your BAu operations.