Functional Field on Report for Time Zone

[Ankit Singh4]

Hi Experts,

Good Day!!

I have a configured a report on incident table where I need to display data in Hourly basis and I can't use time series report for the same. So, I have configured one functional field on report called as "Hour" and return type is "whole number" with substring as glidefunction:substring(sys_created_on,"12","2"). It is giving me an expected result like 2,3,4,5....22,23 but the problem is Incident count in report for the time does not match the sys_created_on time over the table list view. For example: When you click on count which comes under 6 hour it will redirect you on list view of table records where created time should be 06:XX:XX. But in my case both are different due to time zone. And, when I set my time zone as UTC it works properly.
Now, I am unable to understand why it is taking the UTC time? even I did not configured anything like time zone for functional field OR to resolve this issue can we put any condition on functional field related to time zone with the script?

Any help will be really appreciated.

Thanks,

Ankit

[MireilleEdwards]

Hello,

I would be very interested in finding a solution to this as well.  We have defined function fields to pull "Year-Month" for various dates, i.e. Resolved, Closed, etc., so that we can create pivot tables with the "Year-Month" as the columns. 

     Example:

          Function Field Name: Resolved Year_Month

          Function Definition: glidefunction:substring(resolved_at,1,7)

This results in a value that looks like "2025-02" or "2025-03".  Unfortunately, the when the function looks at the 'resolved_at' field, it's seeing it in UTC, not Central Time which is our instance default.  So, if I use filter criteria in my report and try to limit it to Incidents resolved in March of 2025, I still see some items showing up in the 2025-04 column because they were resolved at 10 or 11 pm Central Time on 3/31 which is 4/1 UTC.

@Thomas Davis I've reviewed the 4/5/2023 Academy session but couldn't find a definitive answer as to whether or adjusting for time zone is possible.  Can you provide some guidance?

Thanks,

Mireille