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:
1)
VatFormat ( 987 654 321 )
2)
VatFormat ( NL 123.456.789B01 )
  Sample output:
1)
BE 0987.654.321
2)
NL123456789B01

  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 ).

 

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.