IBAN_VALID

Description

IBAN_VALID checks whether a string is a structurally valid IBAN (International Bank Account Number). It verifies the country code, length, and mod-97 checksum as defined by the ISO 13616 standardarrow-up-right. It does not verify whether the account actually exists.

Syntax

IBAN_VALID(iban)

Returns: true if the IBAN is structurally valid, false otherwise.

Example

IBAN_VALID('CH5604835012345678009')

This returns true.

IBAN_VALID('CH0000000000000000000')

This returns false — the checksum does not pass.

Example in context

p is Person
IBAN_VALID(p.bank_account_number)

Returns true if the account number entered by the user is a valid IBAN. Commonly used as a condition to trigger a validation error or block case progression until a correct IBAN is provided.

Last updated

Was this helpful?