- 30 May 2023
- Print
- PDF
Display Formats
- Updated on 30 May 2023
- Print
- PDF
Search lists in Aspire enable you to specify the fields of information that should be displayed and allow you to control the display format of the information (dollar sign, percent, decimal place, date format, etc.). Display formats can only be specified for numeric and date fields. Generally, Aspire provides an appropriate default format, but you can adjust the format if necessary. This is especially useful for fields created for which Aspire cannot determine the appropriate format.
You can specify display formats by clicking the Displayicon at the top of each search list screen to launch the Display screen:
The string you specify in the Format field determines how values will be formatted when displayed in a search list. Aspire supports two styles that can be used to yield similar results: new and legacy. The legacy format is still supported, but Aspire recommends using the new format – especially for currency and numeric values.
Legacy formatting was provided for numbers based on combinations of the following symbols; “$”, “#”, “.”, “%” and “0”; and for dates with symbols “M” (month), “d” (day), “y” (year), “h” (hours), “m” (minutes), “s” (seconds) and “tt” (am/pm). The new formatting string specifies whether the value should be represented as currency, percent, numeric, date, full date/time, or general date/time (c, p, n, d, F, or g). Here are some common examples of the new and legacy formats.
Format Style | Format Type | Format String | Example Value | New Representation |
New | Currency | c | -1234.567 | ($1,234.57) |
Currency | c3 | 1234.567 | $1,234.567 | |
Numeric | n1 | 1234.567 | 1,234.6 | |
Numeric | n | 1234.567 | 1,234.57 | |
Percent | p1 | .123 | 12.3% | |
Date | d | September 12, 2017 11:33 am | 9/12/2017 | |
Date | F | September 12, 2017 11:33 am | Tuesday, September 12, 2017, 11:33:00 AM | |
Date | g | September 12, 2017 11:33 am | 9/12/2017 11:33 AM | |
Date | G | September 12, 2017 11:33 am | 9/12/2017 11:33:00 AM |
Format Style | Format Type | Format String | Example Value | Representation |
Legacy | Currency | $###,###,###.000 | -1234.567 | $-1,234.57 |
Currency | $###,###,###.000 | 1234.567 | $1,234.567 | |
Numeric | ###,###,###.0 | 1234.567 | 1,234.6 | |
Numeric | ###,###,###.0 | 1234.567 | 1,234.57 | |
Percent | ###.0% | .123 | 12.3% | |
Date | MMMM dd, yyyy hh:mm:ss tt | September 12, 2017 11:33 am | September 12, 2017 11:33:00 AM | |
Date | MM/dd/yy hh:mm.ss tt | September 12, 2017 11:33 am | 09/12/2017 11:33 AM |