Dates and times in XactInsights

Updated by Mara K

Starting on July 31, 2025, all dates within XactInsights are displayed as Coordinated Universal Time (UTC), the global time standard used to ensure consistency and avoid ambiguity across different time zones.   

By standardizing all timestamps to UTC, systems can accurately compare, sort, and query time-based data without being affected by regional time zone differences or daylight-saving time changes. This approach is especially important in distributed applications, where users or systems may operate in multiple geographic locations.   

Due to this change, most of the dates displayed within XactInsights appear earlier than expected if the report includes other Verisk products such as Xactimate and ClaimXperience. 

You can build a formula to see dates and times in XactInsights displayed in your local time. 

  1. Navigate to Search in XactInsights. 
  2. Select the plus symbol next to Formulas to create a new formula.
  3. Add a title for your formula. 
  4. Input the following formula: add_minutes (Received Date , -360) 
Note: To convert UTC to your local time zone, subtract the difference in minutes. For example, in the summer, Mountain Standard Time is 6 hours behind UTC, which is 360 minutes.  

 

With Daylight Saving Time 

Without Daylight Saving Time 

Eastern 

-240 (-4 hours) 

-300 (-5 hours) 

Central 

-300 (-5 hours) 

-360 (-6 hours) 

Mountain 

-360 (-6 hours) 

-420 (-7 hours) 

Pacific 

-420 (-7 hours) 

-480 (-8 hours) 

You might need to update the formula when Daylight Saving Time begins or ends. 
  1. Select Save. 
  2. Apply the formula to your search. 

How Did We Do?