Need Advice - How to list the store hours of a location on the location table

[Sysop]

I have a request from management to add the store hours for each store on the location table.  I have an excel sheet with a few hundred locations that looks like this.  The site code, name, and Region already exist on the table so I need to add hours for each day of the week along with the Time Zone.  Any advice on the best method to do this?

[Kieran Anson]

Depending on how this data is intended to be used, you could either reference a schedule, add a custom field for each date on the location table, or create a new table that references the location

[Sysop]

For the location table, all of our locations have time_zone set to the home office time zone where incidents are handled.  If I update time_zone for each location to the actual time zone of that store, how will this effect incidents and requests that are coming in?  Will the opened_at time be set to that locations time zone or will it still be set to the time zone that was set in the system settings general tab?  Will there be any other adverse effects?

Also, is there a way to include the "Hours" section I added in the location preview on the incident table?

Here is what it looks like though in the preview.  I want to include the hours in the preview.

[Hitoshi Ozawa]

Hi Sysop,

ServiceNow keeps date/time in UTC internally and would convert the date/time to user's date/time when displaying. As such, it is best to keep all date/time in UTC and allow each user to see the entire date/time in time zone set for that user.

If there is a use case to see date/time in each location's time zone, create a script to convert the date/time to each location's time zone. Maybe have to checkbox to toggle between displaying all date/time in user's time zone and in each location's time zone.

Whether to use Schedule or to add custom fields for each day of the week, I may opt to use schedule if holidays also needs to be considered. It would be easier to calculate operating hours with schedule and if there is a need to keep manage employees hours at each location, it would be easier with Schedule.

The downside with using Schedule is that it's a different table so maintenance may be a little bit more difficult compared to just adding custom fields to location table. Data only needs to be imported to the location table.