Math Functions > Time Functions

 

Shift in Time

The Shift in Time function shifts the times in time series data sets by a specified increment or to start at a specified date and time.  The original data values are removed from the file when the shifted data is stored.  To accomplish this, the data sets must be saved immediately following the operation.  For example, if you shift data by one year from 1965 to 1966, data will exist for 1966 and not 1965.  To retain the original data, use the Copy in Time function.   Data sets may be regular or irregular interval time series data.

 

To shift times in time series data sets:

  1. Choose the Time Functions tab of the Math Functions screen and select the Shift in Time operator, as below.
  2. Select a data set to apply the function from the Selected Data Set pull-down list at the top of the screen or multiple data sets from the list in the lower portion of the screen.  If you include the data set selected in the top Selected Data Set, the operation on that set will only be done once.
  3. In the Shift by Amount box, enter the amount of the time to shift the data sets by (integer values only) and then select Minute, Hour, Day, Week, Month or Year.  To shift data backwards in time, use a negative amount for the time shift.
  4. Alternatively, you may select the Shift to Date/Time radio button and specify the date and time to shift the first value in each data set to.


    Screen for Shift in Time Function