Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Formatting

Time Format

In the field:
{
expression
Format
format
}
where expression is a time value, the
format
 is interpreted as a list of ingredients where each ingredient either specifies a component value (hour, minute, second, ampm) or is treated as a static character that will always appear.
For example, in the format text:
"hh24:mm:ss"
the ingredients are:
Ingredient
Description
hh24
hour component (00-23)
:
static character
mm
minute component (01-12)
:
static character
ss
second component

Time ingredients

The full list of ingredients for a time format:
Ingredient
Component
Description
hh24
24-hour
formatted as 2 digits (00-23)
h24
24-hour
formatted as 1 or 2 digits (0-23)
hh12
12-hour
formatted as 2 digits (01-12)
h12
12-hour
formatted as 1 or 2 digits (1-12)
ampm
12-hour
am/pm
AMPM
12-hour
midnight/a.m./midday/p.m.
mm
minute
formatted as 2 digits (00-59)
m
minute
formatted as 1 or 2 digits (0-59)
ss
second
formatted as 2 digits (00-59)
s
second
formatted as 1 or 2 digits (0-59)
note
1. The am/pm names depend upon the locale setting in
Contract Express Administrator
.
2. If you do not apply a format to a time value it will use the locale format which is "hh12:mm:ss" for both the english_uk and english_usa locales.
3. Time ingredients are case-sensitive, so ampm is different from AMPM.
4. If you want the letter "s" to be treated as static text, use "^s". This applies to all ingredients, so "^a^m^p^m" represents the static text "ampm".

This article applies to:

  • PRODUCT: Contract Express