Brian Dunning's FileMaker Custom Functions

IsValidTFN ( text )

Validate TFN

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

James   James
Personal
http://www.null.com

Share on Facebook Share on Twitter

  Sample input:
IsValidTFN ( 987654321 )
  Sample output:
0

  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.

References:
http://www.clearwater.com.au/code/tfn
IsValidABN ( text )

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.