How do I use time zones in Klipfolio?

Specifying time zones in Klipfolio can help ensure your Klips are displaying accurate data. For example, data might be brought into Klipfolio from one region with the intention of displaying the data in a different region. Or an account might have users from all over the world that require Klips to be displayed in one time zone that everyone can understand. Situations like these require a flexible approach and a need for specific time zone settings.

This article lists methods for setting time zones in Klipfolio:

  • Setting a time zone at the account level
  • Setting time zones using the Properties panel
  • Setting time zones using Date/Time functions

Setting a time zone at the account level

You set your time zone at the account level to apply the same time zone to all Klips.

To change the account level time zone setting:

  1. Click on your company name on the top-right corner of the screen and select Account from the dropdown list.
  2. Click on the Settings tab.
  3. Select General from the menu on the left.
  4. Locate the Set Time Zone setting and click Edit.
  5. Select your time zone from the dropdown menu or use your browser setting.
  6. Click Save.

The default setting for the account level time zone is GMT. When the account level time zone is changed, the updated time zone becomes the default time zone of your account instead of GMT. All Klips will display in the account level time zone, unless specified with other time zone settings in the Klip Editor.

You can also select Use Browser Time Zone to use the current time zone of your browser. However, if the browser time zone changes, the account level setting will not update.

Setting time zones using the Properties panel

You can set time zones in the Properties panel of the Klip Editor when data is detected or set as Date/Time. You use the dropdown menu under Input Format and/or Display Format to apply a time zone to the selected component.

To use this setting, deselect Use default time zone. The Input Format is the date/time format and time zone of the raw incoming data. The Display Format is the date/time format and time zone of the data displayed in the Klip.

Time zones specified in the Properties panel override Account level time zone settings.

NoteThe time zone property for Input Format may not be visible if your dates are in Unix time format or if you have a Custom Input Format that includes a Z in the format.

Setting time zones using the Properties panel for a Date Picker

When working with a User Input Control component, you have the option of using a Date Picker control. This enables you to set variables using a calendar dropdown. With this component type, Display Format is the date/time format you want your date to display as, in your User Input Control component.

Once a date is selected from the calendar dropdown, that date/time is used as your variable value. The Output Format is the date/time format of your variable value.

If your Output Format is in Unix time, you can use the Use end of day value option so when you choose a date from the Date Picker, the Unix time value will be the chosen date at 11:59 PM. 

Note: If you want to use date filtering on your date variable, the Output Format must be in Unix time. 

Setting time zones using Date/Time functions

Needing to specify a time zone using functions is uncommon but can be done by using the timezone parameter of some Date/Time functions. When using the timezone parameter, type your time zone offset or region as a string in the formula bar.

In Klipfolio, time zones are specified by offset and region and change according to Daylight Savings. You can use either format when specifying a time zone in Date/Time functions and date parameters in data source queries. See this page for a list of supported time zones.

Learn more: