How To: Date Format Localization in Looker

[emilydetmer]

Context

• There is no out of the box setting for date format localization as of 10/26/23
  • You can localize descriptions and labels in your model, following these instructions.
• You can format dates using liquid, following these instructions
  • How can we use user attributes to drive date formatting?

Instructions

First create a User Attribute to drive the date formats. In our example, we will have some US based users and some EU based users.

Create a new dimension for your formatted date. Then use the html parameter to format your date in a liquid if statement that references your user attribute.

This is how both of these dimensions will appear to an end user with the eu value in their date_location user attribute.

Next we need to think about how this dimension will appear to our user in the explore. Instead of two separate dimensions, we want our new date dimension to replace the existing Date timeframe in the Created Date dimension group. This will also allow us to use one dimension in the same report that will have different formatting depending on the user.

Remove the Date timeframe from the Created Date dimension group

Add type, group_label, and label parameters to the new formatted dimension

Now this is how the dimension group appears to an eu user: