Skip to main content
Kofax

Time Zone Settings and Offsets

Article # 3039963 - Page views: 34

Issue

How can date fields be configured to offset the time zone for data loads?

 

Solution

This feature was introduced in Insight v6.2.1 and documented in Studio's on-line Help system.

This article explains how to use the Timezone offset feature of Insight and how the configuration of this feature can impact the resulting data set returned during a data load.

Example use-case:

1.       Insight server is in CA, Pacific Time Zone

2.       Data in the source database is Eastern Time Zone.

3.       Sample source database:

 

2022-05-26 14_37_17-Window.png

In our Insight project, we have a data source for the above table. The date field is configured for Eastern time zone. This has no processing impact yet.

2022-05-26 14_37_22-Window.png

To load the data into a record with the adjusted time, the record’s date field’s property must have Convert to Server Time enabled (checked). When the data load runs, the Insight server’s time is used as the base time zone to determine the offset. Since our Insight server is in CA, Pacific is used as the base zone.

 

2022-05-26 14_37_26-Window.png

 

 

Example 1:

A data load runs using the default date filter:

2022-05-26 14_37_35-Window.png

 

 

A data load using a time range of 13:00 to 14:00 will retrieve data from the source with that range (Eastern), however, the data loaded into the record will be adjusted. That means an entry of 13:00 in the data source will be written into the record’s date field as 10:00 AM, the time difference between the Insight server and the time zone configured for this date field in the data source. Below is the record’s data load with time adjusted:

 

2022-05-26 14_37_39-Window.png

 

 

Example 2:

Date filters can optionally be configured to use special offset functions, FromDateWithTimezone(dateField) and ToDateWithTimezone(dateField). Each of these takes a date field as a parameter.

 

2022-05-26 14_37_44-Window.png

 

This changes the behavior of the data load by first adjusting the time zone to the specified time zone configured in the data source’s date field (Eastern), then loading the data. The data written into the record is done identical to the prior Example.  Note that a different data set is retrieved into this record compared to Example 1 and the time updated to reflect the offset:

 

2022-05-26 14_37_48-Window.png

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
Insight 6.2.1 and newer      

 

Article # 3039963
  • Was this article helpful?