Date/Time formats

You can format a date and/or time in a predefined format or in a format that you define.

 

Contents  [Hide]

 

The formats featured in this topic only apply to these GainSeeker modules:

The formats for SPC Data Entry, DMS Data Entry, SPC Charts and Reports, DMS Charts and Reports, and Enterprise Dashboard modules are likely to differ from those featured in this topic. See Date/Time formats for information that applies to these GainSeeker modules.

Predefined date/time (standard) formats

The table below identifies the predefined (standard) date/time format names. Only those commonly used with GainSeeker are featured. See Examples below. For information on other formatting options, see the Microsoft .Net documentation.

Format Specifier

Format Name

Description

d

Short date pattern

Display a date according to the short date format in the workstation's regional options. For example, "MM/dd/yyyy."

D

Long date pattern

Display a date according to the long date format in the workstation's regional options. For example, "dddd, dd MMMM yyyy."

f

Full date/time pattern (short time)

Display a combination of the long date (D) and short time (t) patterns, separated by a space.

F

Full date/time pattern (long time)

Display a date and time according to the long date format in the workstation's regional options. For example,
"dddd, dd MMMM yyyy HH:mm:ss."

g

General Date/time pattern (short time)

Display a combination of the short date (d) and short time (t) patterns, separated by a space.

G

General Date/time pattern (long time)

Display a combination of the short date (d) and Long time (T) patterns, separated by a space.

M or m

Month day pattern

Display a custom DateTime format string defined by the month and day property set in the workstation.
For example, MMMM dd."

User-defined (custom) date/time formats

The table below identifies characters you can use to create user-defined (custom) date/time formats. Only those commonly used with GainSeeker are featured. See Examples below. For information on other formatting options, see the Microsoft .Net documentation.

Character

Description

:

Time separator. The time separator separates hours, minutes, and seconds when time values are formatted. The actual character used as the time separator in formatted output is determined by the time separator in a workstation's regional options.

/

Date separator. The date separator separates the day, month, and year when date values are formatted. The actual character used as the date separator in formatted output is determined by the date separator in the workstation's regional options.

"

Display the literal value of any string between two quotation marks ("). Precede each quotation mark with an escape charter (\).

'

Display the literal value of any string between two.

%c

Display the custom format specifier c preceded by a (%) to indicate that specifier is the only component of a string. To use "d," "f," "F" . . . , specify "%d," "%f," "%F" . . .  .

\c

display the character "c" as a literal when that character is preceded by the escape character (\). Use two escape characters (\\) to insert the backslash character itself in the result string.

Any other character

Any other character is copied to the result string and does not affect formatting.

d

Display the day as a number without a zero preceding single digits (1–31).

dd

Display the day as a number with a zero preceding single digits (01–31).

ddd

Display the day as an abbreviation (Sun–Sat).

dddd

Display the day as a full name (Sunday–Saturday).

f

Display the most significant digit of the seconds fraction. (For each "f" character added, one additional significant digit will display. For example, for ffff, the four most significant digits of the seconds fraction will display.

F

Display the most significant digit of the seconds fraction; nothing is displayed if the digit is zero. (For each "F" character added, one additional significant digit will display. For example, for FFFF, the four most significant digits of the seconds fraction will display. Trailing zeros do not display.)

g or gg

Display the period or era (A.D., for example) except when the date to be formatted excludes an associated period or era string.

h

Use the twelve-hour clock and display the hour as a number without a zero preceding single-digit hours (1–12). The time "5:43" would display "5."

hh

Use the twelve-hour clock and display the hour as a number with a zero preceding single-digit hours (01–12). The time "5:43" would display "05."

H

Use a zero-based twenty-four-hour clock and display the hour as a number without a zero preceding single-digit hours (0–23).

HH

Use a zero-based twenty-four-hour clock and display the hour as a number with a zero preceding single-digit hours (0–23).

K

Display different values of the DateTime.Kind property such as "Local," "Utc," or "Unspecified." Local: equivalent to the zzz specifier, displaying the local offset from GMT; UTC: Display a "Z" character to represent a UTC date; Unspecified: equivalent to "" (nothing).

m

Display the minute as a number without a zero preceding single-digit minutes (1–59).

mm

Display the minute as a number with a zero preceding single-digit minutes (01–59).

M

Display the month as a number without a zero preceding single-digit months(1–12).

MM

Display the month as a number with a zero preceding single-digit months (01–12).

MMM

Display the month as an abbreviation (Jan–Dec).

MMMM

Display the month as a full name (January–December).

s

Display the second as a number without a zero preceding single-digit seconds (0–59).

ss

Display the second as a number with a zero preceding single-digit seconds (00–59).

t

Displays the first character of the A.M. or P.M. designator.

tt

Display the A.M. or P.M. designator.

y

Display the day of the year as a two-digit number without a zero preceding single-digit years (1–99).

yy

Display the year as a two-digit number with a zero preceding single-digit years (01–99).

yyy

Display the year as a three-digit number with zeros preceding single-digit years (001–999).

yyyy

Display the year as a four-digit number with zeros preceding single-digit years (0001–2099).

yyyyy

Display the year as a five-digit number with zeros preceding single-digit years (00001–02099).

z

Display the time zone offset of a workstation from the Greenwich Mean Time (GMT) in hours without a zero preceding single-digit hours (-12 to +13). The offset is always preceded by a minus sign (-) to indicate hours behind GMT, or a plus sign (+) to indicate the hours before GMT.

zz

Display the time zone offset of a workstation from the Greenwich Mean Time (GMT) in hours with a zero preceding single-digit hours (-12 to +13). The offset is always preceded by a minus sign (-) to indicate hours behind GMT, or a plus sign (+) to indicate the hours before GMT.

zzz

Display the time zone offset of a workstation from the Greenwich Mean Time (GMT) in hours and minutes with a zero preceding single-digit hours or minutes (-12:00 to +13:00). The offset is always preceded by a minus sign (-) to indicate hours/minutes behind GMT, or a plus sign (+) to indicate the hours/minutes before GMT.

Date/Time format examples

Format string

Output when regional options are
set to English (United States):

d

10/23/2024

F

Tuesday, October 23, 2024 11:26:59 AM

M/d/yy

10/23/24

d-MMM

23-Oct

d-MMMM-yy

23-October-24

d MMMM

23 October

MMMM yyyy

October 2024

hh:m tt

11:26 AM

h:mm:ss t

11:26:17 A

h:mm

11:26

h:m:ss

11:26:45

M/d/yy h:mm

10/23/2024 11:26

Related topics