AMQL Docs
AML ReferenceData Format

Date Format

How the format property works on date dimensions and measures in AML, with the day, month, year, and separator tokens and the patterns each one accepts.

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 PatternsExample
dd/LL/yyyy or dd-LL-yyyy08/02/2000 or 08-02-2000
LL/dd/yyyy or LL-dd-yyyy12/13/2022 or 12-13-2022
LLL dd yyyyJan 01 2022
LLL dd, yyyyJan 01, 2022
dd LLL, yyyy12 Jan, 2002
LLL yyyyJan 2022
yyyy2022

AML Types

This document describes the built-in types supported by AML, and how to define your own custom types

Number Format

Use the format property to control how number fields display currency symbols, thousands separators, decimal places, percentages, and abbreviations (K, M, B).

On this page

Overview of Date FormatDay partMonth partYear partSeparatorSupported Date Format patterns