An administrator can configure the way DateTime, Date, and Time field values are displayed in the application. This does not affect how values may be imported, but can be used to standardize or simplify the display to users.
There are three separate format selectors available for dates, date-times, and time-only values, as shown in the image below. For each, you can check the box to Use Default or select the pattern you prefer.
Date, Time, and DateTime display formats are selected from a set of standard options, giving you flexibility for how users will see these values. DateTime fields combine one of each format, with the option of choosing "<none>" as the Time portion.
Date formats available:
Format Selected | Display Example |
---|---|
yyyy-MM-dd | 2024-08-14 |
yyyy-MMM-dd | 2024-Aug-14 |
yyyy-MM | 2024-08 |
dd-MM-yyyy | 14-08-2024 |
dd-MMM-yyyy | 14-Aug-2024 |
dd-MMM-yy | 14-Aug-24 |
ddMMMyyyy | 14Aug2024 |
ddMMMyy | 14Aug24 |
MM/dd/yyyy | 08/14/2024 |
MM-dd-yyyy | 08-14-2024 |
MMMM dd yyyy | August 14 2024 |
Time formats available:
Format Selected | Display Example |
---|---|
HH:mm:ss | 13:45:15 |
HH:mm | 13:45 |
HH:mm:ss.SSS | 13:45:15.000 |
hh:mm a | 01:45 PM |
Format strings for Integer and Decimal fields must be compatible with the format that the java class DecimalFormat accepts. A valid DecimalFormat is a pattern specifying a prefix, numeric part, and suffix. For more information see the Java documentation. The following table has an abbreviated guide to pattern symbols:
Symbol | Location | Localized? | Meaning |
---|---|---|---|
0 | Number | Yes | Digit |
# | Number | Yes | Digit, zero shows as absent |
. | Number | Yes | Decimal separator or monetary decimal separator |
- | Number | Yes | Minus sign |
, | Number | Yes | Grouping separator |
The following examples apply to Decimal fields.
Format String | Display Result |
---|---|
<no string> | 85.0 |
0 | 85 |
000 | 085 |
.00 | 85.00 |
000.000 | 085.000 |
000,000 | 085,000 |
-000,000 | -085,000 |