Brian Dunning's FileMaker Custom Functions

VatFormat ( vat ; country )

Correct the format of a VAT number ( BE, NL & DE )

  Average rating: 4.5 (31 votes) Log in to vote

Michael Bijnens   Michael Bijnens
freelance developer

Share on Facebook Share on Twitter

  Sample input:
VatFormat ( 987 654 321 )
VatFormat ( NL 123.456.789B01 )
  Sample output:
BE 0987.654.321

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

Michael Bijnens - Junior FileMaker Analyst / Programmer

Use this custom function the correct the vat input.

2 values are needed; the vat input number ( just digits ) and the country code ( short ).

To check the vat number you can use this custom function in combination with the " CheckVatBE " ( only belgian vat numbers ).



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.