Brian Dunning's FileMaker Custom Functions

IsValidTFN ( text )

Validate TFN

  Average rating: 5.0 (2 votes) Log in to vote

James   James

Share on Facebook Share on Twitter

  Sample input:
IsValidTFN ( 987654321 )
  Sample output:

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

Validates Australian TFN (Tax File Numbers) numbers. The result is either 0 (not valid) or 1 (valid ). Null imput evaluates to 1.

It ignores all spaces and other separators.

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

Currently suitable for 9 digit TFN only.

IsValidABN ( text )



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.