Using Date/Time Shifting Transform

Date/Time shifting allows you to offset the date/time values in your dataset. You can offset the dates by a quarter, to times of only a minute. This gives you more flexibility to tailor the data according to your requirement.

Does your data come in a timezone that's not your own? Use the date/time shifting transform to shift the timezone of your data.

To do this, click on the +Add Transform button, then select Date/Time Shifting near the bottom or the list.

The window that pulls up, shows you four fields:

  • Column: Select the date or time column that you want to use for this transform.

    You can also use Dynamic Dates option. This will let you select a date like "Today", and you can add the date/time shift to that. In this case, you have to create a new column.

  • Operator: Set whether you want to add or subtract a time period. If you choose '+', and select 1 hour, the values in the selected date column will go ahead by 1 hour.
  • Number and Interval: Use these fields to get the exact time period to add or subtract. For example, to add a 2 month time period to the dates, type 2 in the Number field and select month for the Interval.

You can create a new column for the transformed information, or you can use the same column for the new values. To create a new column, select the Create New Column check box. After you have selected the check box, type in a name for the new column in the text box which appears alongside.

After making the changes, select Save to save the configuration.

To use this for setting offset from the UTC time, select the date column, add or subtract the number of hours of offset and give a new name for the column.


Identifying the time zone of a data source

We are actively working to improve this, but the short answer is it depends on the data source.

The first thing you should do is google the data sources API. For example you can google "What timezone is Shopify API in?"

Adding the term API will help differentiate from the results of people using the native application.

If you are having trouble you can also reach out to our support team.

If a timezone is widely known for a data source, we will include that information in the Data Source help article as well.

Was this article helpful?