Salesforce Spring '23 Release Update - Enable ICU Locale Formats

Salesforce Spring '23 forces a release update for locales: Salesforce | Adopt the ICU Locale Formats

It means that Locale formats for dates and times will be changed from the previous Oracle’s Java 8 Development Kit (JDK8) format to the new International Components for Unicode (ICU) formats for dates and times. The reason behind the update is that Salesforce wants to provide a consistent experience across the Salesforce platform and improve integration with ICU-compliant applications across the globe.

For ADvendio users, this is of particular importance as some key features within ADvendio work with logic handling different locales:

  • Media Configuration

  • Commercial Optimizer

  • Booking Calendar

  • PDFs

  • Publication Dates / Publication Date selection

  • Ad Manager Kanban


Where?

This change applies to Lightning Experience, Salesforce Classic, and all versions of the Salesforce app in all editions, except Database.com.


When?

Salesforce enforces this update in Spring ’23 (to be released around february 2023). Salesforce orgs created in Winter ’20 (after October 14, 2019) have ICU locale formats enabled by default. To get the major release upgrade date for your instance, go to Trust Status, search for your instance, and click the maintenance tab.


What to do?

We added a setting on ADvendio side in our version 2.144 to apply the new standard also in our features. Please take note that you will need to have that version or newer installed to test the impact of the ICU Release Update appropriately.

For further steps, please decide: 

You can check the creation date of your org via Setup > Company Information and check the Created By field. It will show the name and the relevant date when the org was created.

If your Salesforce org was created before Winter '20 (before October 14, 2019)

  1. Before enabling this update in production, evaluate the new locales’ impact to your Salesforce org.
    As mentioned by Salesforce you can use this SOQL query to find the locales in use in your org and a user count for each locale.

    1 SELECT toLabel(LocaleSidKey) LocaleName, LocaleSidKey, Count(id) UserCount FROM User where IsActive=true GROUP BY LocaleSidKey
  2. To enable this update, from Setup, in the Quick Find box, enter Release Updates, then select Release Updates. For Enable ICU Locale Formats, follow the testing and activation steps.

  3. As soon as you enabled the ICU update on Salesforce side, please also activate the ICU formats in ADvendio.

    1. To do this, from the App Launcher, search for Feature Settings and open the object.

    2. Look for the Feature setting with the Feature Setting name “ICUFormats“ (created in version 2.144 and above) and update the Value as described below:

      1. Feature Setting Name: ICUFormats

      2. Feature Name: ReleaseUpdate

      3. Template Name: -

      4. New Value: {"active":true} → (change the value back to {"active":false} when you finished testing and don't want to activate ICU yet)

  4. For testing you should have a look at the features mentioned at the top of this page: Media Configuration, Commercial Optimizer, Booking Calendar, PDFs, Publication Dates / Publication Date selection, Ad Manager Kanban.
    Please check especially those process steps where you are working with dates, times and numbers.

If your Salesforce org was created in Winter '20 or later (after October 14, 2019)

  1. When your org was created after October 14, 2019 the Salesforce Release Update "Enable ICU Locale Formats" was enabled for a test run by default.

  2. If the Release Update is still enabled can be checked by the steps below: 

    1. Go to Setup > in the Quick Find box, enter Release Updates, then select Release Updates.

    2. Look for "Enable ICU Locale Formats" and press the "Get Started" button.

    3. On the page you will probably see the section as shown below - this means that the ICU Formats update is enabled. If the button says "Enable Test Run" the release update was disabled. 

    4. To decide based on the screen:

      1. In case the test run is disabled in your org (button says "Enable Test Run") please continue with the chapter above (starting from 1.) in order to prepare for enabling ICU formats in your org.

      2. If the test run for ICU formats is still enabled (button says "Disable Test Run") please continue with the steps below.

  3. In order to prepare ADvendio for use with ICU formats you will need to change a feature setting.

    1. To do this, from the App Launcher, search for Feature Settings and open the object.

    2. Look for the Feature setting with the Feature Setting name “ICUFormats“ (created in version 2.144 and above) and update the Value as described below:

      1. Feature Setting Name: ICUFormats

      2. Feature Name: ReleaseUpdate

      3. Template Name: -

      4. New Value: {"active":true} 

  4. For testing you should have a look at the features mentioned at the top of this page: Media Configuration, Commercial Optimizer, Booking Calendar, PDFs, Publication Dates / Publication Date selection, Ad Manager Kanban.
    Please check especially those process steps where you are working with dates, times and numbers.