Timezone handling in Capillary UI ensures that:

• Dates and times are displayed consistently
• Scheduling aligns with business expectations
• Support teams see predictable timestamps
• Time-based promotions behave correctly

Default Display Behaviour

Unless specified otherwise:

• Dates and times are displayed in the organization timezone.
• The organization timezone is configured at the account level.
• All users see a consistent reference timezone across supported modules.

Module-wise behaviour

Member Care

• By default, all date and time values are displayed in the base organization timezone..
• You can select a different timezone using the timezone dropdown.
• Available timezones are populated from the supported timezones configured in your organization settings.

This allows support teams to view timestamps in the customer’s local context when required.

Promotions (New UI)

During creation

• You can select a timezone from a dropdown.
• The dropdown lists timezones in IANA format (for example, Asia/Shanghai, Europe/London).
• The available timezones in the dropdown are populated from the supported timezones configured in your organization settings.
• The selected timezone defines the local time context in which the promotion is scheduled.

On the listing page

• Duration is displayed in the timezone selected during creation.
• Updated at is displayed in the organization timezone.

This ensures that scheduling context is preserved while maintaining consistent audit references.

Streaks

During creation and on the listing page, all date and time values follow the organization timezone.

Milestone

During creation and on the listing page, all date and time values follow the organization timezone.

Offers (Gift voucher)

During creation and on the listing page, all date and time values follow the organization timezone.

Cart promotion

During creation and on the listing page, all date and time values follow the organization timezone.

Campaigns

• During creation, all date and time values use the organization base timezone.
• You cannot select a different timezone during creation.
• The campaign listing and detail pages also display dates and times in the organization base timezone.

Audience

• The audience listing page displays all date and time values in the organization timezone.
• Date range filters use server time.

Journeys

The listing page and detail page display all date and time values in the organization timezone.

Insights

All timestamps are normalized to the server timezone (IST / Asia/Kolkata) to ensure chronological accuracy and consistency in reporting across all fact tables in Databricks.

Timezone normalization in Insights is config-driven and controlled by an org-level feature flag (ENABLE_INSIGHTS_TIMEZONE_CONVERSION).

🚧

Important

Enabling timezone conversion applies only to new data going forward. Existing historical data is not automatically updated. A full re-sync is required if you need historical data corrected. Discuss this with your Capillary account team before enabling, especially if you sync Databricks data to an external data warehouse.

For full details on how Insights handles timezone in Databricks, including the feature flag, impact on historical data, and step-by-step enablement, see Timezone Handling in Databricks Tables.