Brian Dunning's FileMaker Custom Functions

IsValidABN ( text )

Validates Australian ABN numbers.

  Average rating: 4.0 (36 votes) Log in to vote

Vaughan Bromfield   Vaughan Bromfield

Share on Facebook Share on Twitter

  Sample input:
IsValidABN ( 11 111 111 111 )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Validates Australian ABN numbers. The result is either 0 (not valid) or 1 (valid ). Null imput evaluates to 1.

It ignors all spaces and other separators.

This function uses the checksum algortithm as published by the Australian Government.



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.