DT409 Format component

DI000179 Pos.

DI000196 Component

Number format:

Values

• Start in powers of ten
• Max. no. of digits before the decimal place: 16
• Max. no. of decimal places: 8

Examples

• -2: two decimal places
• 3: thousands
• etc.

Date format:

Values

• Grid specification:
  • 2: day
  • 3: week
  • 4: month
  • 5: quarter
  • 6: year:

DI000199 Separator

Any required separating character may be specified here (including a blank or @ for

). Upon input:

• separators will be converted as appropriate for the format.

For numbers, the first separator is specified as decimal separator.

DI000201 DB length

The length specifies how many characters are displayed. Number format:

Values

• In powers of ten

Date format:

• It is cut-off on the right side; for yearly grids it is cut off on the left side.

Examples

• Length = 3 for weekday
  • Result: Constant Monday is displayed as Mon .
• Length = 2 for year
  • Result: Constant 1994 is displayed as 94 .

DI000205 Zeros

This data item determines whether a format component is filled with zeros. Number format:

Examples

• Required display xxxxxx,yy with two format components, let the current value be 900,5.
• If the DI Zeros
  • is only set for places after the decimal point, 900.50 will be displayed
  • is only set for digits before the decimal point, 000900.5 will be displayed
  • is set for both components, 000900.50 will be displayed

Date format:

Examples

• The desired display is MM/DD/YY. With the components
  • Day: Zeros = and Length =2
  • Month: Zeros = and Length =2
  • Year: Zeros = and Length =2
• the date 5/1/2002 will then be displayed as 05/1/02.

DI000206 CONST

Here, the ID of the constant is specified. Date format:

Values

• 000100 Week day (small letters)
• 000110 Week day (capital letters)
• 000130 Month (small letters)
• 000150 Month (capital letters)
• 000170 Quarter
• 000120 DW
• 000121 CW
• 000122 Week
• 000123 FY

Note

• The constant IDs for sequential constants (e.g. Monday, Tuesday, Wednesday) must be ascending without gaps.

Note

• Constants are created and edited in the Text Constants module.

DI028148 Constant

Shows the name of the text constant displayed in the Constant field

DI000200 Display

Values

• 1: Plain text after text constant
• 2: Cardinal number
• 5: Company calendar
• 99: Placeholder for format constants (units)
• The following values are only reasonable for formats of the Scale type.
  • 6: Grid line
  • 7: Shading
  • 8: Fix line
  • 9: Start line
• The following values are not active:
  • 3: Ordinal number, incrementing
  • 4: Ordinal number, descending

DI000226 Value

Number format: If you use component 99, the number of hours per person day is stored here for the conversion of the person days constant (and vice versa).. The input can also be made in the form of @G or @D variables.

Date format: Is used for simplified date input.

• I.e., it is possible to only enter the day in date input while month and year will be complemented.

Example

• A date format consisting of one component each for day, month, and year: The month and year components in the Value data field each receive the @15 default value.

Currency format: If you use component 99, a currency symbol can be stored here.

Note

• Only currency symbols which have been defined in the Currencies and Exchange Rates module.

DI027236 Conversion factor

DI000208 Blank

Sets a blank space before the component.

DI000217 Trim

Date format:

Values

• : Removes blank spaces and zeros, e.g.: "01/01/96" becomes "1/1/96".
• : Blank spaces and zeros are not removed.

Note

• Can be applied to each individual component of a format.

DI000225 Rounding

DI002282 Line