Format editor allows you to define display format for date, time, and numeric values. You can create custom formats or can also use default formats for the objects. Custom formats are used when default format doesn’t meet the requirement.
Default formats are based on common locale data repository CLDR. You can select from 15 default formats for Date and time, and 4 formats for numeric values.
Custom formats can be created using the format editor. Custom format contains text and tokens. A token is defined as predefined part of date or numeric value.
There are 15 date and time format tokens that are defined using the format editor. Consider the following date and time tokens for category - Day.
|Day 01-31||Day is represented by 2 digits 01-31|
|Day 1-31||Day is represented by 1 or 2 digits from 1-31|
|Day Name||Day Name like Monday, Tuesday|
|Short Day Name||Day Name like Mon, Tue|
|Day of year||Day is represented by 3 digits - 001-366|
|Day of year 01-366||Day is represented by 2 or 3 digits - 01-366|
|Day of year 1-366||Day is represented by 1, 2, or 3 digits|
|Day of week in a month||Day of the week in month like 2 for 2nd Tuesday of July|
|Uppercase Day Name||Day name in uppercase - Tuesday|
|Lowercase Day Name||Day name in lowercase - Tuesday|
|Capitalized Day Name||Day name starts with capital - Tuesday|
|Uppercase short day name||Day name is represented in short format in uppercase - Mon|
|Lowercase short day name||Day name is represented in short format in lowercase - Mon|
|Capitalized short day name||Starts with capital in short format like - Mon|
Similarly, there can be time tokens for minutes, hour, week, month, quarter, and year format.
A number format section can be defined as consists of −
Consider the following example, which shows how a number can be displayed using different format defined in the editor.
Example − How number -1,234 will be displayed using number tokens?
|Format Defined with Tokens||Preview Display|
|Revenue: [Sign always][#][Decimal separator]||Revenue: 1234.00|
You can use different list of number format tokens like sign, digit, separators, exponents, percent, and Boolean.