Display Formats
  • 30 May 2023
  • PDF

Display Formats

  • PDF

Article summary

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 StyleFormat TypeFormat StringExample ValueRepresentation

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


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Eddy AI, facilitating knowledge discovery through conversational intelligence