Skip to main content

Locale date formats


Locale date formats

Date formats in the Zuora UI and other features (for example, invoice PDFs, quote PDFs, and Data Source Exports) are based on the locale settings in your tenant.

For example, if you set the locale setting in your user profile to English (United States), Zuora displays the account creation date as 02/14/2022 on a customer account page. After you update the setting to English (United Kingdom), the date is displayed as 14/02/2022.

This article explains the locale settings that determine date formats in Zuora UI and other features except Zuora API. For more information about date formats in the Zuora API, see Date and dateTime formats.

Locale date formatting conventions

Zuora supports the following locale date formatting conventions:

Locale setting Formatting convention Example
Dansk (Danmark) DD-MM-YYYY 14-02-2022
Deutsch (Deutschland) DD.MM.YYYY 14.02.2022
English (United Kingdom) DD/MM/YYYY 14/02/2022
English (United States) MM/DD/YYYY 02/14/2022
español (España) DD/MM/YYYY 14/02/2022
français (France) DD/MM/YYYY 14/02/2022
italiano (Italia) DD/MM/YYYY 14/02/2022
português (Portugal) DD-MM-YYYY 14-02-2022
日本語 (日本) YYYY/MM/DD 2022/02/14

Locale settings in Zuora

You can configure locale settings in the following profiles in your tenant:

  • Tenant profile
  • User profile
  • Communication profile

Different profiles control the date format of different features.

Locale setting in tenant and user profiles

The locale setting in tenant profile and user profile controls the date format of the following features:

  • Zuora UI
  • Data Source Exports from Zuora UI
  • Quote PDFs
  • Import Customer Account
  • Import Payment Method
  • Mass Order Entry (Subscription and Amendment)
  • Usage Upload
  • Reporting
  • Custom fields (Date and Datetime custom field types)

The locale setting in user profile takes precedence over the locale setting in tenant profile.

For more information about how to manage these profiles, see Managing your tenant profile and Edit your user profile.

Locale setting in communication profiles

The locale setting in communication profiles controls the date format of the following features:

  • Email notification (merge fields from Data Source Exports)
  • Invoice PDFs

Note that Zuora uses English (United States) as the default locale for communication profiles.

The following table explains the date format details of merge fields in notifications:

Notification type Merge fields from Data Source Exports Legacy merge fields
Email notification Determined by the locale setting Not determined by the locale setting
Callout notification YYYY-MM-DD Not determined by the locale setting

For example, if you set the locale setting in the communication profile to English (United Kingdom), the <DataSource.Subscription.TermEndDate> merge field from Data Source Exports in an email notification is in the format of DD/MM/YYYY. However, the date format of the <Subscription.TermEndDate> legacy merge field in the same email notification is not affected.

For more information about how to manage the communication profiles, see Communication profiles.