Salesforce Docs Portal

Custom Time Zone Considerations

Keep these considerations in mind when working with custom time zones.

Required Editions

Available in Salesforce Classic and Lightning Experience.
Available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in: Developer Edition
Create Data Source Links in a Time Zone Enabled Dashboard
You can create data source links using date fields (DateOnly and DateTime) in time zone enabled datasets. If two datasets are linked using the parent date field (such as CreateDate), all components of the date field (such as year and year-month) are automatically linked.
Data source links between a static step and an individual date component of a DateOnly or DateTime field aren’t supported.
Bind Dates in a Time Zone Enabled Dashboard
When binding dates in a time zone enabled dashboard, you refer to date fields differently. Note the following differences between GMT-only dashboards and time zone enabled dashboards.
GMT-Only Dashboards Time Zone Enabled Dashboards
cell(myStep.selection, 0, "CloseDate_year") cell(myStep.selection, 0, "year_CloseDate")
cell(myStep.selection, 0, "CloseDate_year~~~CloseDate_month") cell(myStep.selection, 0, "year-month_CloseDate")
asEquality("CreateDate_year", "Region") asEquality(["year", "CreateDate"], "Region")
asDateRange("CreateDate('year', 'month', 'day')") asDateRange("CreateDate")
Use Compact Form Queries in a Time Zone Enabled Dashboard
When adding dates in compact form queries, the syntax is different in time zone supported dashboards. Note the following differences between GMT-only dashboards and time zone supported dashboards.
Query Component GMT-only Dashboards Time Zone Supported Dashboards
Date Measure 
"measures": [
    ["sum", "Ship_Date_day_epoch"]
]
 
"measures": [
    ["sum", ["epochDay","Ship_Date"]]
]
Group by Date 
"groups": [
    "CloseDate_Year"
]
 
"groups": [
    ["year", "CloseDate"]
]
Group by Date 
"groups": [
    [
        "CloseDate_Year",         
        "CloseDate_Quarter"
    ]
]
 
"groups": [
    ["year-quarter", "CloseDate"]
]
Filter by Date 
"filters": [
  [
     "Created Date",
     [
         [
            1359504000000,
            1486425600000
         ]
     ],
     ">=<="
  ]
]
 
"filters": [
  [
    "Created Date",
    [
       [
          "2013-01-30 00:00:00",
          "2017-02-02 23:59:59"
       ]
    ],
    ">=<="
  ]
]
Filter by Date 
"filters": [
  [
    "Opportunity.CloseDate",
      [
        [
          [
            "quarter",
            -2
          ],
          [
            "quarter",
            0
          ]
        ]
      ],
      ">=<="
  ]
]
Unchanged
Order by Date 
"Order": [
 [
  "CreateDate_year", 
  {
   "ascending": true
  }
 ]
]

"order": [
  [
   ["year", "CreateDate"],
   {
    "ascending": true
   }
  ]
]
Other Considerations
You can’t view converted date-time values in a lens.
Time zone enabled dashboards don’t support these features:
  • Notifications
  • Subscriptions
  • Watchlists
  • Natural language queries
  • Data source connections between a static step and a dataset date field
  • Displaying month names, such as “Jan” and “Feb” (months display as numbers only, such as “01” and “02”)
  • Remote text-based search on date fields in list widgets