Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

HolidaysAUS ( theYear )

Rate this function:  

  Average rating: 4.9  (23 votes)
  Discuss this Custom Function

Vaughan Bromfield, Vaughan Bromfield Design

Creates a paragraph-delimited list of dates for Australian national holidays.

Sample Input:
HolidayAUS ( 2011 )
Sample Output:

 Then copy & paste into FileMaker Advanced's Edit Custom Function window.


HolidaysAUS ( theYear )

Written by Vaughan Bromfield

v1.0 - 22 October 2012
v1.1 - 23 October 2012 -- added historical limits, changed to List()
v1.2 - 23 October 2012 -- allowed for ANZAC Day clash with Easter Monday in 2011

Returns a list of paragraph-delimited dates for Australian national public holidays. Does not return dates that fall on Saturday or Sunday.
The holiday list has a NSW bias and includes the NSW dates for Queens Birthday and Labour Day.
An attempt has been made to include the proclamation years of the holidays to give them historical limits, but these are not complete nor 100% correct.
Arguably I could exclude any year before 1788 when Australia was first colonised by Europeans, or 1901 when Australia became independent from Britain.

Calculates the standard public holidays for Australia (actually NSW):
New Years Day
Australia Day
Good Friday
Easter Monday
Queens Birthday (All states except WA)
Labour Day (ACT, NSW, SA)
Christmas Day
Boxing Day

Includes code from the custom function
Easter_Sunday ( TheYear )
by Menno van Beek, STB Automatisering & Advies BV.

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

This is my Custom Function and I want to edit it


All though your sample input is correct

RectangleArea ( 2 , 3 ) is 6 as seen in the saample output. I am not quite sure what this has to do with a cf that gets Austrailian holidays?

Robert Schaub, East Hampton CT
October 22, 2012 6:43am

Updated, thanks.

Vaughan, Sydney AUstralia
October 22, 2012 3:59pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 9 + 5 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. ChiSquare3x2 ( param ; param ; param ; param )
  (Tue, Aug 14, 6:33am)
2. ReverseByteOrder ( bytes )
  (Thu, Aug 09, 12:06pm)
3. BytesToDec ( hex )
  (Thu, Aug 09, 11:47am)
4. GetAsHexBytes ( number ; bytes )
  (Thu, Aug 09, 10:50am)
5. ValCorrelationCoeff ( XValueList; YValueList; Xmean; Ymean; XStdDev; YStdDev )
  (Wed, Aug 08, 4:17pm)
6. ValLeastSquaresSlope ( XValueList; YValueList; Xmean; Ymean )
  (Wed, Aug 08, 4:10pm)
7. ValueMath ( List1 ; List2 ; operation )
  (Wed, Aug 08, 4:05pm)
8. GetExtension ( File )
  (Tue, Aug 07, 10:22am)

RSS Feed of Custom Functions