Use of format elements

If you select the same format element more than once for the same item, that item may not be validated separately. If you specify MON twice, the day of the month is not validated separately for both months. For example, if the date format element MON is used twice for a single item, with the following format string:

MON D-MON D

Suppose the data is this:

Feb 28-Mar 31

28 is not validated for the month of February.

Some combinations of reserved words are invalid. A separator must follow reserved words representing a variable number of digits (D and M for date) if data follows.

For example:

  • D/M/CCYY is valid.
  • CCYYM/D is valid.
  • DMCCYY is invalid.