Date, Time, and Number Formats

Sample Manager Help
This topic covers formatting options for formatting the display of dates, times, and numbers within Sample Manager and other similar applications.

Set DateTime, Date, and Time Display Formats

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.

  • Select > Application Settings.
  • When the Use Default box is checked, you will be inheriting a default setting.
  • Uncheck the box and choose a different Display format for date/date-times/time-only values if desired.
  • Click Save.

DateTime, Date, and Time Display Options

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 SelectedDisplay Example
yyyy-MM-dd2024-08-14
yyyy-MMM-dd2024-Aug-14
yyyy-MM2024-08
dd-MM-yyyy14-08-2024
dd-MMM-yyyy14-Aug-2024
dd-MMM-yy14-Aug-24
ddMMMyyyy14Aug2024
ddMMMyy14Aug24
MM/dd/yyyy08/14/2024
MM-dd-yyyy08-14-2024
MMMM dd yyyyAugust 14 2024

Time formats available:

Format SelectedDisplay Example
HH:mm:ss13:45:15
HH:mm13:45
HH:mm:ss.SSS13:45:15.000
hh:mm a01:45 PM

Number Format Strings

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:

SymbolLocationLocalized?Meaning
0NumberYesDigit
#NumberYesDigit, zero shows as absent
.NumberYesDecimal separator or monetary decimal separator
-NumberYesMinus sign
,NumberYesGrouping separator

Examples

The following examples apply to Decimal fields.

Format StringDisplay Result
<no string>85.0
085
000085
.0085.00
000.000085.000
000,000085,000
-000,000-085,000

Related Topics

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand allcollapse all