IsValidTFN ( text )
Average rating: 5.0 (2 votes) Log in to vote
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 )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.