Invoice modulesSpecification of date fields (Invoice Manager)
FYI: DOCUMENTS INI File Help contains links to this topic.
Note that this information applies to the fields used with invoice profiles (more information). Fields are also used when preparing document specifications (more information).
FYI: INI File Help contains links back to this topic.
When creating a date field, leave the box in the group box blank to let the system select date formats.
Alternatively, you can type a format string that includes each of the three required parts of the date (day, month, and year) in the sequence they appear on the invoice. The date formats that can be used are shown below. (See also: Syntax for format strings in field definitions, field profiles, and identifiers)
|
Format |
Alternate format |
Meaning |
|
D |
D(1) |
Day written with one or two digits, 1-31 |
|
DD |
D(2) |
Day written with two digits, 01-31 |
|
M |
M(1) |
Month written with one or two digits (1-9, 10, 11, or 12) |
|
MM |
M(2) |
Month written with two digits, 01-12 |
|
MMM |
M(3) |
Month written with the first three letters of the name. (JAN, FEB, etc.). This is controlled by the |
|
MMMM |
M(4) |
Full month name. Warning: MMMM is the long month name, controlled by the |
|
Y |
Y(1) |
Year written with one or two digits, 8, 98 … (the tens digit may be omitted for the years 2000-2009) |
|
YY |
Y(2) |
Year written with two digits, for example 09 |
|
YYYY |
Y(4) |
Year written with four digits, for example 2009 |
|
X |
|
Separator character |
Notes
The field's setting is important.
To ensure better validation of dates, only dates between these two boundaries are valid:
-
Dates from the current date minus 150 years.
-
Dates from the current date plus 100 years.
Separator characters in date fields
Choosing the field format type: regular, date, or amount (Invoice Manager)