Date Format

Note

To apply Date Format for your dimension/measure, ensure its type is date.

Overview of Date Format

To format your date fields, add a format property with a string pattern representing your chosen format.

dimension order_created_at_raw {
  label: "Order Created At Raw"
  type: "date"
  format: "dd-LL-yyyy"
}

dimension order_created_at {
  label: "Order Created At"
  type: "date"
  format: "dd LLL, yyyy"
}

Day part

dd

• Example: 01, 12

Month part

LL or LLL

• Description: You can use the numeric value, or the three-letter abbreviation for months.
• Example: 08, 12, Jan, Jul

Year part

yyyy

• Example: 2012, 1990

Separator

- or / or , or <space>

• Example: 09/01/1990

Supported Date Format patterns

Date Patterns	Example
dd/LL/yyyy or dd-LL-yyyy	08/02/2000 or 08-02-2000
LL/dd/yyyy or LL-dd-yyyy	12/13/2022 or 12-13-2022
LLL dd yyyy	Jan 01 2022
LLL dd, yyyy	Jan 01, 2022
dd LLL, yyyy	12 Jan, 2002
LLL yyyy	Jan 2022
yyyy	2022