Date format:Values
Examples
- Start in powers of ten
- max. no. of digits before the decimal point: 16
- max. no. of decimal places: 8
- -2: two decimal places
- 3: thousands
- etc.
Values
- Grid specification:
- 2: day
- 3: week
- 4: month
- 5: quarter
- 6: year
ValuesDate format:
- In powers of ten
Examples
- It is cut-off on the right side, and on the left side for yearly grids.
- Length = 3 for week day
- Result: The Monday constant is displayed as Mon
- Length = 2 for year
- Result: The 1994 constant is displayed as 94
ExampleDate format:
- Required display xxxxxx,yy with two format components, let the current value be 900,5
- If the Zeros DI
- is only set for places after the decimal point, the output is 900.50
- is only set for digits before the decimal point, the output is 000900.5
- is set for both components, the output is 000900.50
Example
ValuesNoteNote
- 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
- The constant IDs for sequential constants (e.g. Monday, Tuesday, Wednesday) must be ascending without gaps.
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 as a @G or @D variable.
See also: Customizing Example |
Used for simplified date input.Currency format:Example
- I.e., it is possible to only enter the day for the date input while month and year are added.
- A date format consisting of one component each for day, month, and year: The Month and Year components each receive the @15 default value in the Value field.
If you use component 99, a currency symbol can be stored here. Note
- Only currency symbols that are created in the Currencies and Exchange Rates module can be used.
ValuesNote
- : removes blank spaces and zeros, e.g.: "01/01/96" becomes "1/1/96".
- : blanks and zeros are not removed.