Format check

Format checks are performed on the date, check digit, time, currency code, and country code fields.

For date fields, the format check verifies that the date provided is valid. The format check ensures the range of the month, day, and year are valid and also that the date is valid. For example, 2/29/2008 is valid since 2008 was a leap year, but 2/29/2007 fails because 2007 was not a leap year.

A format check for a check digit is computed from the characters given and compared to the given check digit to verify it is correct.

For a time field, format check verifies the hour and minute are within the appropriate ranges. The hour range is 0 - 23 and the minute range is 0 - 59.

The following table shows the formats that are supported.
Table 1. Supported formats
Format Description
YYYYMMDD Date, where:
YYYY
Is the year
MM
Is the month
DD
Is the day
YYMM Date, where:
YY
Is the year
MM
Is the month
MMDD Date, where:
MM
Is the month
DD
Is the day
MMYY Date, where:
MM
Is the month
YY
Is the year
hhmm Time, where:
hh
Is the hour (0 - 23)
mm
Is the minutes (0 - 59)
hhmmss Time, where:
hh
Is the hour (0 - 23)
mm
Is the minutes (0 - 59)
ss
Is the seconds (0 - 59)
TTTTAAAAC Routing number with check digit, where:
TTTT
Is a Federal Reserve prefix number
AAAA
Is an ABA institution identifying number
C
Is the check digit for the first eight digits
bTTTTAAAAC Routing number with check digit, where:
b
Is a blank
TTTT
Is a Federal Reserve prefix number
AAAA
Is an ABA institution identifying number
C
Is the check digit for the first eight digits
C Check digit is a single character field that checks the preceding eight characters.
TTTTAAAA Routing number without check digit, where:
TTTTAAAA
Is all digits
CP00RSNNN Canadian ICL format, where:
C
Is the currency indicator
P
Is the item type
00
Is always zeros
R
Is the region code
S
Is the processing site
NNN
Is the financial institution number
CanadianRT Validation uses the Canadian routing transit number format.
CountryCode All two letter country codes as defined in ISO 3166.
CurrencyCode All three letter and three digit currency codes as defined in ISO 4217.