Parsing dates
The rules defined in this section apply to Transaction Date and Value Date.
LocateStep
The parser recognizes dates in the following formats:
| MMM =JAN, FEB, …, DEC; MM or M is a numeric value between 1 and 12. |
| DM YY | DD.M.YY | D-MMM-YY | M-D-YY |
| DMM YY | DD.M.YYYY | DMMMYYYY | M-D-YYYY |
| DMMM YY | DD.MM.YY | D-MMM-YYYY | MM.D |
| DMMM YYYY | DD.MM.YYYY | D-MM-YY | MM.D.YY |
| D.M | DD.MMM.YY | D-MM-YYYY | MM.D.YYYY |
| D.M.YY | DD.MMM.YYYY | D-M-YY | MM.DD.YY |
| D.M.YYYY | DD/M | D-M-YYYY | MM.DD.YYYY |
| D.MM | DD/M/YY | M.D | MM/D |
| D.MM.YY | DD/M/YYYY | M.D.YY | MM/D/YY |
| D.MM.YYYY | DD/MM/YY | M.D.YYYY | MM/D/YYYY |
| D.MMM.YY | DD/MM/YYYY | M.DD | MM/DD/YY |
| D.MMM.YYYY | DD-M | M.DD.YY | MM/DD/YYYY |
| D/M | DDMMMYY | M.DD.YYYY | MM-D |
| D/M/YY | DD-MMM-YY | M/D | MM-DD-YY |
| D/M/YYYY | DDMMMYYYY | M/D/YY | MM-DD-YYYY |
| D/MM | DD-MMM-YYYY | M/D/YYYY | MM-D-YY |
| D/MM/YY | DD-MM-YY | M/DD | MM-D-YYYY |
| D/MM/YYYY | DD-MM-YYYY | M/DD/YY | MMMDD YY |
| DD M YY | DD-M-YY | M/DD/YYYY | MMMDD YYYY |
| DD MM YY | DD-M-YYYY | M-D | YY.MM.DD |
| DD MMM YY | D-M | M-DD | YYMMDD |
| DD MMM YYYY | D-MM | M-DD-YY | YYYY.MM.DD |
| DD.M | DMMMYY | M-DD-YYYY | YYYYMMDD |
Where one of the following words optionally appears in the preceding n characters (a configurable value), the located date is processed as a transaction date:
| DT | SENT | 100 | 205 |
| DATED | ON | 103 | INSTRUCTION |
| DATE | OF | 202 | PAYMENT |
| DTD | DATD | 200 | P/O |
| DD | MT | 201 | FOR |
| POSTED | ORDER | 203 | P.O. |
However, if one of the following optional words appears in the preceding n characters, the located date is processed as a value date:
- VALUE
- VAL
- VALUED
- V/D
- V.D.
Manipulate/TranslateStep
If a date is found, it is converted to the standard Java DATE format (not DATETIME).
Test/ValidateStep
The following test conditions are possible as part of a When rule:
| Is{Located Date} < $TODAY | Is{Located Date} = $TODAY |
| Is{Located Date} <= $TODAY | Is{Located Date} > $TODAY |
| Is{Located Date} >= $TODAY | Is{Located Date} < {.DateProperty} |
| Is{Located Date} = {.DateProperty} | Is{Located Date} <= {.DateProperty} |
| Is{Located Date} > {.DateProperty} | Is{Located Date} >= {.DateProperty} |
Map/Output Step
If the Test/Validate step returns TRUE, or no test/validate step is used and data has been successfully located, the output is saved as a property.
Previous topic Appendix C: Text parsing rules Next topic Parsing Amounts