Format (format)

The Format property controls the output of a numeric or date display.

In the Properties view, this property is the Format property in the Value category.

For DECIMAL data types, format-string consists of pound signs (#) that represent digits and a decimal point. For example, "###.##" produces three places to the left of the decimal point and exactly two to the right.

For DATE data types, format-string consists of formatting symbols, as in Table 1, and separating values such as "/". The formatting symbols can use either uppercase or lowercase letters. For example, "YYYY-MM-DD".

Table 1. Formatting Symbols for Dates
Character Description
dd Day of the month as a two-digit integer.
ddd Three-letter English-language abbreviation of the day of the week, for example, Mon, Tue.
mm Month as a two-digit integer.
mmm Three-letter English-language abbreviation of the month, for example, Jan, Feb.
yy Year, as a two-digit integer representing the two trailing digits.
yyyy Year as a four-digit number.

See the BDL format attribute for additional information and format characters.

Type: String.