IsValidBankaccount

The IsValidBankAccount() function checks whether the input parameter is a valid Dutch bank account format.

Note: this function only works for Dutch Bank Accounts and is an old (though still valid) implementation using the old account-number 11-proof checks. Still available for backwards compatibility in existing projects.

The function IsValidIBAN() can be used for validating IBAN account numbers.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns true if parameter is a valid Dutch bank account.

Returns false if parameter is not a valid Dutch bank account

Syntax

IsValidBankAccount(accountnr, ing)

IsValidBankAccount("736160221", false) => True

IsValidBankAccount("12345678", false) => False

Parameters

Name	Type	Required	Description
accountnr	text	☑️	Field that is checked for a value
ing	Yes/No	☑️	True when its an ING bank account False when it is not an ING bank account